Search found 84 matches
- Mon Dec 27, 2010 9:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert 24:00:00 value into time field on DB2
- Replies: 6
- Views: 4783
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...
- Thu Dec 23, 2010 10:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert 24:00:00 value into time field on DB2
- Replies: 6
- Views: 4783
Insert 24:00:00 value into time field on DB2
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...
- Wed Dec 15, 2010 2:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using Parameter Set In DB2_UDB_API stage
- Replies: 1
- Views: 1965
- Wed Dec 15, 2010 1:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using Parameter Set In DB2_UDB_API stage
- Replies: 1
- Views: 1965
Using Parameter Set In DB2_UDB_API stage
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.
- Fri Dec 03, 2010 9:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: string to timestamp error
- Replies: 12
- Views: 26794
- Thu Dec 02, 2010 5:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: string to timestamp error
- Replies: 12
- Views: 26794
- Thu Dec 02, 2010 5:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: string to timestamp error
- Replies: 12
- Views: 26794
- Thu Dec 02, 2010 5:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: string to timestamp error
- Replies: 12
- Views: 26794
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') ...
- Thu Dec 02, 2010 3:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: string to timestamp error
- Replies: 12
- Views: 26794
string to timestamp error
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 ...
- Wed Nov 17, 2010 10:18 am
- Forum: General
- Topic: Creating loop in Sequence
- Replies: 4
- Views: 3219
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...
- Tue Nov 16, 2010 8:44 pm
- Forum: General
- Topic: Creating loop in Sequence
- Replies: 4
- Views: 3219
- Tue Nov 16, 2010 5:14 pm
- Forum: General
- Topic: Creating loop in Sequence
- Replies: 4
- Views: 3219
Creating loop in Sequence
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...
- Wed Jun 02, 2010 3:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Int32 to Decimal conversion.
- Replies: 5
- Views: 7566
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...
- Fri May 28, 2010 1:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML File size limit
- Replies: 10
- Views: 7259
- Fri May 28, 2010 1:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Int32 to Decimal conversion.
- Replies: 5
- Views: 7566
Int32 to Decimal conversion.
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 ...