DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 84 matches
Author Message
 Topic: Insert 24:00:00 value into time field on DB2
dsdevper

Replies: 6
Views: 3536

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 27, 2010 9:30 am   Subject: Insert 24:00:00 value into time field on DB2
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 ...
 Topic: Insert 24:00:00 value into time field on DB2
dsdevper

Replies: 6
Views: 3536

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 23, 2010 10:54 pm   Subject: Insert 24:00:00 value into time field on DB2
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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.
...
Resolved
 Topic: Using Parameter Set In DB2_UDB_API stage
dsdevper

Replies: 1
Views: 1119

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 15, 2010 2:07 pm   Subject: Using Parameter Set In DB2_UDB_API stage
Sorry .

Yes it can be used by tagging the variable with parameter set name.
Resolved
 Topic: Using Parameter Set In DB2_UDB_API stage
dsdevper

Replies: 1
Views: 1119

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 15, 2010 1:01 pm   Subject: Using Parameter Set In DB2_UDB_API stage
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 t ...
 Topic: string to timestamp error
dsdevper

Replies: 12
Views: 23520

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 03, 2010 9:36 am   Subject: string to timestamp error
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 ...
 Topic: string to timestamp error
dsdevper

Replies: 12
Views: 23520

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 02, 2010 5:27 pm   Subject: string to timestamp error
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 ...
 Topic: string to timestamp error
dsdevper

Replies: 12
Views: 23520

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 02, 2010 5:16 pm   Subject: string to timestamp error
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 fro ...
 Topic: string to timestamp error
dsdevper

Replies: 12
Views: 23520

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 02, 2010 5:03 pm   Subject: string to timestamp error
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. ...
 Topic: string to timestamp error
dsdevper

Replies: 12
Views: 23520

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 02, 2010 3:59 pm   Subject: string to timestamp error
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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),updat ...
 Topic: Creating loop in Sequence
dsdevper

Replies: 4
Views: 1863

PostForum: General   Posted: Wed Nov 17, 2010 10:18 am   Subject: Creating loop in Sequence
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(*) ...
 Topic: Creating loop in Sequence
dsdevper

Replies: 4
Views: 1863

PostForum: General   Posted: Tue Nov 16, 2010 8:44 pm   Subject: Creating loop in Sequence
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 ...
 Topic: Creating loop in Sequence
dsdevper

Replies: 4
Views: 1863

PostForum: General   Posted: Tue Nov 16, 2010 5:14 pm   Subject: Creating loop in Sequence
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 co ...
 Topic: Int32 to Decimal conversion.
dsdevper

Replies: 5
Views: 6188

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 02, 2010 3:01 pm   Subject: Int32 to Decimal conversion.
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))
...
 Topic: XML File size limit
dsdevper

Replies: 10
Views: 4731

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 28, 2010 1:47 pm   Subject: XML File size limit
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 ...
 Topic: Int32 to Decimal conversion.
dsdevper

Replies: 5
Views: 6188

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 28, 2010 1:43 pm   Subject: Int32 to Decimal conversion.
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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.

" ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours