Search found 39 matches
- Fri Aug 01, 2014 8:57 am
- Forum: General
- Topic: Datastage job triggering issue from Tivoli
- Replies: 0
- Views: 1400
Datastage job triggering issue from Tivoli
Hi, I am triggering a script with different parameters, that triggers a datastage Parallel job with different instances at same time. Sometimes they are running as expected and some times jobs are failing with the following error: ERROR: Failed to lock job Status code = -10 DSJE_JOBLOCKED When I re-...
- Mon Jun 30, 2014 2:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in Reading a SQL Server Stored Procedure
- Replies: 2
- Views: 1772
- Mon Jun 30, 2014 11:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in Reading a SQL Server Stored Procedure
- Replies: 2
- Views: 1772
Issue in Reading a SQL Server Stored Procedure
Hi, I am trying to read a SQL Server Stored Procedure in the following way in ODBC Connector Stage: DECLARE @TEST int Exec dbo.spValidateLoadProcess 'xyztable', @TEST OUTPUT SELECT @TEST abc Then I am getting an error as Null Arguement:pDataSetDef Can anyone help me in accessing this procedure. If I...
- Mon Sep 09, 2013 1:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Increment Counter based on Stage Variable
- Replies: 4
- Views: 3445
- Mon Sep 09, 2013 12:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CHECKPOINT_DIR
- Replies: 2
- Views: 2849
- Tue Aug 20, 2013 3:46 pm
- Forum: General
- Topic: dsexport.exe command - Help required.
- Replies: 3
- Views: 3053
- Mon Aug 19, 2013 1:05 pm
- Forum: General
- Topic: dsexport.exe command - Help required.
- Replies: 3
- Views: 3053
dsexport.exe command - Help required.
I want to export job with executable individually at command line. I am using dsexport.exe command, it is prompting to a window where in we need to reenter the user id , password and project details again. I don't want any another window to be prompted. Directly using a single command I need the exp...
- Mon Jul 30, 2012 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing Sequence level resources at job level
- Replies: 1
- Views: 1597
Passing Sequence level resources at job level
Hi, I am using a sequence job which has one parallel job. APT CONFIG FILE at project level is set to 2 nodes. In sequence job, I have added APT CONFIG FILE parameter and assigned 4 node configuration file to it. But my parallel job present in the sequence is running on 2 nodes only. I want to run th...
- Wed Nov 02, 2011 2:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: replace | with |"
- Replies: 6
- Views: 2753
- Wed Nov 02, 2011 12:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: replace | with |"
- Replies: 6
- Views: 2753
replace | with |"
Hi,
My requirement is to replace | with |"
i tried with convert('|','|"', inputcolumn). But this doesn't solve the requirement.
Please suggest me how to solve this. My output is one shared container for which i have to send the data in this format.
My requirement is to replace | with |"
i tried with convert('|','|"', inputcolumn). But this doesn't solve the requirement.
Please suggest me how to solve this. My output is one shared container for which i have to send the data in this format.
- Fri Oct 28, 2011 7:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Strip double quotes at end of the record
- Replies: 4
- Views: 2752
- Fri Oct 28, 2011 1:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Strip double quotes at end of the record
- Replies: 4
- Views: 2752
- Fri Oct 28, 2011 12:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Strip double quotes at end of the record
- Replies: 4
- Views: 2752
Strip double quotes at end of the record
Hi, I have my source record as abc|"1234|"xyz|"1|"|" xyz|"3244|"342|"|"|" I have Strip |" at the end of each record. How I can accomplish removing quote characters... I tried with trim function and mentioned |" as delimiter field but it was...
- Thu Sep 08, 2011 12:13 pm
- Forum: General
- Topic: dsjob run command--- Failed to open project
- Replies: 6
- Views: 6216
- Thu Sep 08, 2011 10:41 am
- Forum: General
- Topic: dsjob run command--- Failed to open project
- Replies: 6
- Views: 6216