Search found 138 matches
- Fri Aug 03, 2012 12:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector Stage ( Bulk Load )
- Replies: 4
- Views: 6914
- Fri Aug 03, 2012 9:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector Stage ( Bulk Load )
- Replies: 4
- Views: 6914
- Thu Aug 02, 2012 6:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector Stage ( Bulk Load )
- Replies: 4
- Views: 6914
DB2 Connector Stage ( Bulk Load )
Hi I am using DB2 Connector as Target Stage. Write Mode: Bulk Load. Table action: Append Record count: 2000 Auto commit mode: off Array size: 2000 Load timeout: 90 Directory for named pipe(unixonly): /tmp Copy loaded data: Use device or directory Loaded data copy location: /dev/null ================...
- Fri Jul 27, 2012 1:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector stage using user defined query.
- Replies: 8
- Views: 13323
- Fri Jul 27, 2012 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector stage using user defined query.
- Replies: 8
- Views: 13323
DB2 Connector stage using user defined query.
Hi I am using DB2 Connectore stage as source and target as sequential file stage. My source database is DB2 UDB 9.7, i wrote a user defined query using Rank Function, the result of the Rank capture in to a alias column. I am using the alias column in my Select column list. My problem is when i try t...
- Wed Jul 11, 2012 9:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector stage
- Replies: 4
- Views: 3974
Hi Craig My problem is when i read the data from dataset and write into DB2 Book Mark table i am getting this error and abort the datastage job. I am not getting any single quote or double quote data. Book mark has two columns. one is sequence no ( integer ), keygenerate ( varchar 1024). Thanks SReddy
- Tue Jul 10, 2012 6:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector stage
- Replies: 4
- Views: 3974
DB2 Connector stage
Hi I am getting this working and aborted the job. I created a Book Mark table as part of IBM Infosphere CDC . I capture the Book Mark data in to dataset, in my next job read the dataset and write in to Book_Table using DB2 Connector stage ( write method is Update then Insert ). I saw some one use th...
- Fri Sep 02, 2011 12:48 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Controller problem
- Replies: 3
- Views: 2579
Re: Controller problem
Thanks
I resolved myself.
I resolved myself.
- Fri Sep 02, 2011 9:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Controller problem
- Replies: 3
- Views: 2579
Controller problem
Hi
One of my Sequence job was aborted and getting below error.
Please guide me with useful information.
Thanks
SReddy
One of my Sequence job was aborted and getting below error.
Please guide me with useful information.
SEQ_Test_Job..JobControl (@Waitforfile_Test): Controller problem: Unhandled failure (-14) encountered calling routine DSWaitForFile
Thanks
SReddy
- Wed Aug 31, 2011 2:09 pm
- Forum: General
- Topic: Needs logs for aborted or warning runs
- Replies: 3
- Views: 2422
thanks
I try to getting the logs from datastage directory. When the job Abort or Warning.
Advise me how to right the routines.
First time i am working on Server Routine.
Thanks
SReddy
Advise me how to right the routines.
First time i am working on Server Routine.
Thanks
SReddy
- Wed Aug 31, 2011 9:25 am
- Forum: General
- Topic: Needs logs for aborted or warning runs
- Replies: 3
- Views: 2422
Needs logs for aborted or warning runs
When i try to use the routine posted here I am getting -1.
How you can get logs. Please explain me in reply mail.
How you can get logs. Please explain me in reply mail.
- Tue Jun 14, 2011 9:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: EBCDIC COMP-3 problem
- Replies: 1
- Views: 1654
EBCDIC COMP-3 problem
Hi
I am reading a EBCDIC file one of the column has COMP-3. When i view the data. some of the data is in good format. But most of data is moving to next columns.
i have some special characters in the begining of the columns. Please guide me to resolve the problem.
Thanks
SReddy
I am reading a EBCDIC file one of the column has COMP-3. When i view the data. some of the data is in good format. But most of data is moving to next columns.
i have some special characters in the begining of the columns. Please guide me to resolve the problem.
Thanks
SReddy
- Wed Feb 09, 2011 2:48 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Controller problem: Error calling DSSetParam
- Replies: 3
- Views: 5631
- Wed Feb 09, 2011 8:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Controller problem: Error calling DSSetParam
- Replies: 3
- Views: 5631
Controller problem: Error calling DSSetParam
Hi
When i am running PeopleSoft EPM 9.1 Sequence job, It is aborted and getting this error.
Controller problem: Error calling DSSetParam(SNAP_DT_SID), code=-4
[ParamValue/Limitvalue is not appropriate]
Please help me with useful information.
Thanks
SReddy
When i am running PeopleSoft EPM 9.1 Sequence job, It is aborted and getting this error.
Controller problem: Error calling DSSetParam(SNAP_DT_SID), code=-4
[ParamValue/Limitvalue is not appropriate]
Please help me with useful information.
Thanks
SReddy
- Fri Nov 19, 2010 4:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DSD.UVOpen Unable to open file - Hash File
- Replies: 4
- Views: 8973
DSD.UVOpen Unable to open file - Hash File
hi
I am working on DataStage EPM Server jobs. One of the job creating two hash file. I can view one hash file , when i view another hash file i am getting below error.
DSD.UVOpen Unable to open file
Please respond with remedy.
Thanks
SReddy
I am working on DataStage EPM Server jobs. One of the job creating two hash file. I can view one hash file , when i view another hash file i am getting below error.
DSD.UVOpen Unable to open file
Please respond with remedy.
Thanks
SReddy