DSXchange

Thanks Chulett, I have gone thru the post what you have mentioned, there they have converted 24:0:00 to next day, but in may case as i am migrating a C# code where it is inserting 24:00:00,Client wants to do the same they dont want to convert it to next day. Any idea of how to insert the same value...

Hi , I am getting 24:00:00 from a time field on DB2 ,and i have to insert the same value into a time field on DB2. I am getting following error when trying to insert this value into DB2 table. "TABLE1_Insert,0: Warning: At row 2, link "toxfmDefault", while processing column "TIME...

Sorry .

Yes it can be used by tagging the variable with parameter set name.

Can we use Parameters defined in parameter set in DB2_UDB_API stage.when i am trying to use a variable defined for schema name, in user defined sql it is not picking up the default value.Even when i tried to load database connection credentials, only option i get is Data Connection.

Craig/Ray For "May 12 2003 12:19:52:256" If i use " ss:3" i am not getting the milliseconds i am getting "May 12 2003 12:19:52". If i use " ss.3 " i am getting "does not match format '%mmm %dd %yyyy %hh:%nn:%ss.3': missing the fractional part of the field...

Do you need the field to be Char? Why not leave it as a Timestamp (length 26) and set the Extended property to "Microseconds"? I am converting Char to time stamp .i just did what you said i set it to timestamp(26) and micro seconds then its returning me microseconds as 000000 instead of r...

Craig : I tried as you said replaced %ss.6with 00000 StringToTimestamp(StageVar1,'%mmm %dd %yyyy %hh:%nn:%00000') job failed saying APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%mmm %dd %yyyy %hh:%nn:%00000" for conversion "...

Hi Anbu, Input data 'May 12 2003 12:19:52:256' I changed the format to StringToTimestamp(StageVar1,'%mmm %dd %yyyy %hh:%nn:%ss:%SSS') now i am getting Out put as : May 12 2003 12:19:52. i am missing milliseconds from the output. so i tried StringToTimestamp(StageVar1,'%mmm %dd %yyyy %hh:%nn:%ss.6') ...

Hi My input field is Timestamp but since i was missing the milliseconds from the field i am converting it into char field to get the missing milliseconds. so My sql : select convert(char(23),update_dt,9)) as update_dt from table. My source Data value is Feb 17 1995 12:00:00:000AM(Varchar (26)) when ...

how should i check for return value from storeprocedure. As i am getting a row value as 1 or 0 from storeprocedure. storeprocedure: BEGIN DECLARE c1 CURSOR WITH RETURN FOR SELECT COUNT(*) AS CountOfDependencies FROM SCH.TABLE1 WHERE YEAR = @YEAR_TYPE AND TYPE_ID = 2 -- Updates AND STATUS_ID IN (4, 5...

Thanks Chulett.

I have created sequence jobs but they are very simple, trigger conditions are just to check the job status,if any job_activity returns job status other than '1' stop the sequence or else run the next.i never created a loop sequence depending on the output.

Hi , I need to create a loop in sequence job,in which the loop exit depends upon the value a of store procedure. Store procedure output will be the count of the records from a table ,checking a column value. If the store procedure value is '1' then i should wait for 6o seconds and again call the sto...

Sreedhar : My job design is Reading from Sybase database lookup with oracle table and load oracle table values to target oracle table. oracle(Number(3,0)) | | Sybase --------Lookup---------Oracle(Number(3,0)) Ray : i even tried 1)creating a transformer in which i hard coded a value and defined as ch...

I tried to get that answer from IBM support.But they didn't say the exact size but, They Said 100 MB is preferable size. I tried reading 250 Mb file, i was successful, But higher than that job was terminating abnormally. Here is the Message i got from IBM "" Found that the XML Input stage ...

Hi , Source and Target both are Oracle. My source column in defined as Number(3,0) and target is defined as Number(3,0). Even though they are same datatypes. I am getting following error. "" When writing column INT32 into database column DECIMAL(3,0), truncation, loss of precision or data ...