DSXchange

Ok, I should have stipulated "you cannot have 2 links writing to the same sequential file in the manner you have shown"

Can you try adding an explicit "CAST(<type> AS NULLABLE INT32)"

I would recommend using the DSPrepareJob() routine call in this case, it will reset the job if necessary.

Raghavendra - Even though you can do that, you don't need to. The descriptor file contains a copy of the configuration file used to create that dataset, and it can be used to locate the appropriate directories for the part files.

That means that the $DSHOME/bin directory is not in your environment's path; execute the `$DSHOME/bin/dsjob' command.

You cannot have 2 links writing to the same sequential file. Make both links go to a link collector and then have one link append to your sequential file.

Your command will not work.

try

You need to include "-mode NORMAL" in the command line as well.

Hota, Since the first two lines have a different number of columns to the rest, you can do this with a reject link in your source sequential stage that just dumps those rows into a dummy terminating copy stage. I am not sure from your data if you have tab delimiters or backslash delimiters, plus the...

If the contents of the VarChar() field are actually numeric, then this conversion will function correctly and implicitly.

Along the same lines, check to see how big the log files of the 2 jobs in question are; purge them if necessary or ensure that the autopurge settings are enabled.

Did you confuse Part_Num with Conv_Part_Num? Your posted derivation indicates you are creating Part_Num in the modify stage.

Hello and welcome to DSXchange!

In your Join_68 stage you have declared Conv_Part_Num to be 36 long when in reality it is coming in as 50. Your modify stage has nothing to do with that error.

abc123, All posts that I see regarding re-indexing as well as the command itself state that all users need to be logged out in order for the command to work correctly. I don't see how you can state that the posts in DSXchange got you into trouble. You still haven't stated what else you have done, pe...

dsjob -run -mode NORMAL -param Name=MyName -param Path=/sample/path {project} {job}