DSXchange

Just wanted to mention that I have got this problem in Director.
I recompiled the involved jobs and the error disappeared.

I figured it out with your help Craig.
In the sequencer properties if I select 'Log warnings after activities that finish with status other than OK' the sequencer now finishes with warning.
Many thanks.

In the sequencer, there is a Terminator activity that is called when warning is issued.
However after that terminator the sequencer finishes ok.

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...

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...

Same version DB2 v9.7.0.10

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...

Thank you for your feedback.
The idea was to compile as is without changing anything in the code when migrating from 8.5 to 11.5

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: ...

Finally resolved the issue. The problem was the input file. It was a DOS format file, so the last field of the record ADHPCT was not map properly. After adding the Record delimiter field = DOS format, problem was fixed.
Thanks everyone for your help on this topic.

Thanks Craig and Franklin.
I have tried Franklin advice ... with no success for now.
Got same results. Will investigate further.

Here is the exact syntax:

Input variable ADHPCT
Defined Varchar 6
Value : 98.27

Stage variable svAdhpct
Defined Decimal 5,2

Transformation variable svAdhpct
StringToDecimal(link.ADHPCT)

Output variable ADHPCT
Defined Decimal 5,2
Result in DB2 table : 0.00

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...

Thank you all for your help. Using a file with password has resolved the issue.

Thanks Craig for feedback. I do understand that when we run as-is the command "dsjob -run project job" no authentication is provided. However when we run that exact same command with user dsadm it works but it does not with user dsops. It means when connecting to DS server with dsadm, auth...