Just wanted to mention that I have got this problem in Director.
I recompiled the involved jobs and the error disappeared.
Search found 21 matches
- Mon Dec 10, 2018 8:29 am
- Forum: General
- Topic: Run-time error '5' Invalid procedure call or argument
- Replies: 5
- Views: 6291
- Sun Dec 02, 2018 11:06 am
- Forum: General
- Topic: Job sequencer not returning error status
- Replies: 3
- Views: 2684
- Sun Dec 02, 2018 10:56 am
- Forum: General
- Topic: Job sequencer not returning error status
- Replies: 3
- Views: 2684
- Sun Dec 02, 2018 6:03 am
- Forum: General
- Topic: Job sequencer not returning error status
- Replies: 3
- Views: 2684
Job sequencer not returning error status
Hello, Datastage version 11.5 I do have a Sequencer Job Jq_Batch_Id_Temporaire thats is starting a Parallel Job Jx_Id_Temporaire. This is run thru a dsjob command line in a script as follow : dsjob -server :$DSRPCD_PORT_NUMBER -run -jobstatus w83_dev Jq_Batch_Id_Temporaire STATUS=$? When a warning o...
- Fri Jul 13, 2018 4:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Migration from 8.5 to 11.5 - Handling of carriage return
- Replies: 9
- Views: 5603
This record file has a lenght of 241, last character is D (hexa 44) then a carriage return. So ... Trim(From_Sf_x90txfrd.FICHIER[236,10]) ... get 6 characters from 236 to 241. With 8.5, Trim add the carriage retun and 3 spaces (hexa 0D202020) With 11.5, Trim add 4 spaces (hexa 20202020) so ignore th...
- Thu Jul 12, 2018 1:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Migration from 8.5 to 11.5 - Handling of carriage return
- Replies: 9
- Views: 5603
- Thu Jul 12, 2018 11:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Migration from 8.5 to 11.5 - Handling of carriage return
- Replies: 9
- Views: 5603
Thanks Chulett ... it makes sense. The data in input file is as follow : CNFVCD followed by a carriage return Then transformation : Trim(From_Sf_x90txfrd.FICHIER[236,10]) goes into a CHAR (10) field that get loaded into a DB2 fied defined as CHAR (10) In the DB2 table via DS 8.5 : CNFVCD with carria...
- Thu Jul 12, 2018 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Migration from 8.5 to 11.5 - Handling of carriage return
- Replies: 9
- Views: 5603
- Thu Jul 12, 2018 7:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Migration from 8.5 to 11.5 - Handling of carriage return
- Replies: 9
- Views: 5603
Migration from 8.5 to 11.5 - Handling of carriage return
Hello, We are migrating from DS 8.5 to 11.5. In a parallel job, we read a flat file coming from Mainframe and load the content in a DB2 table. The exact same Datastage code is used for 8.5 and 11.5. When comparing results, for a field defined CHAR(10) : in 8.5 we get the following hexa data in DB2: ...
- Sun Oct 23, 2016 6:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Varchar to Decimal issue
- Replies: 8
- Views: 5732
- Sat Sep 03, 2016 7:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Varchar to Decimal issue
- Replies: 8
- Views: 5732
- Fri Sep 02, 2016 4:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Varchar to Decimal issue
- Replies: 8
- Views: 5732
- Thu Sep 01, 2016 3:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Varchar to Decimal issue
- Replies: 8
- Views: 5732
Varchar to Decimal issue
I have a file with a varchar numeric field containing a maximum of 6 caracters (for example 3.45 or 23.45 or 234.56). I need to load this field in a DB2 table where the field is defined (decimal 5,2). I have tried many possibilities using stringtodecimal function with no success mainly due to the de...
- Thu Jul 07, 2016 1:27 pm
- Forum: General
- Topic: Status code = -14 DSJE_TIMEOUT
- Replies: 15
- Views: 11403
- Wed May 25, 2016 11:40 am
- Forum: General
- Topic: Status code = -14 DSJE_TIMEOUT
- Replies: 15
- Views: 11403