DB2 | Forum profile

Hi <a href=http://www.jomtienbeachhotel.com/>order acomplia</a> This drug is available in two forms: 10 and 20 mg. buy acomplia It must be taken on empty stomach for faster absorption and it is suggested to avoid eating breakfast for 1 hour after taking the medication. CHEAP ACOMPLIA \ Buy Generic Acomplia \ Acomplia Online Without Prescription \ Buy Acomplia (Rimonabant) Medication \ Acomplia Diet Pill \ Acomplia...

Quote: Originally Posted by db2girl Oh, I see what you mean by 4 days. The answer remains the same or the answer is zero. What does it meat ZERO ? Oh, DB 2 girl ! Lenny

Google for "dynamic SQL". Also check out the PREPARE statement in the manual.

This is not New Year. What is your answer?

There are some (tricky) ways, like in the following example. But, I want to recommend to use CASE expression. Because it describes naturally the meaning of the column. Code: ------------------------------ Commands Entered ------------------------------ SELECT col1 , COALESCE(LEFT('N', 1 + col1 - col1), 'Y') AS funcs , DECODE(col1, col1 + 1, 'Y', 'N') AS decode , CASE WHEN col1 IS NULL THEN 'Y'...

Where are the pictures? What good is a calendar without pictures?

Quote: Originally Posted by rpkulkarni I am writing a stored procedure which has two cursors. How to make TEMP_VALUE to be treated as column name rather than a value? Thanks, rpkulkarni At the beginning Quote: set statement1=' insert into OUTPUT select * from table where cast(? as char(30)) = 2'; PREPARE S1 FROM statement1; And inside the loop Quote: EXECUTE S1 using TEMP_VALUE; Not tried, but hope this helps. DBFinder

sir as spill files generates in target server but the size of each files is different. The files size is different coz its according to source server means when there a huge amt of transaction happens for example 5000 MB in source and after that commit happens, so as spill file of 5000MB will be generated in target Kindly correct me on this ?? regds Paul

You need to do everything as the instance owner (db2inst1 in your case). To see the databases: db2 list db directory To determine which version: db2level To see the tables: db2 connect to MyDB db2 select tabschema,tabname from syscat.tables Andy

Could you be more specific about any errors seen ? Regards, Sawan Gupta