DSXchange

As you may know, when convert Decimal to String, a leading space and trailing full stop will exist. Can Modify stage achieve the convertion without space and full stop? I know E:string[5] = substring[0,5](A) C:string[7] = string_from_decimal(B) But when I use the following statement, it failed with ...

I have asked similar question before, but still can't solve this problem. Someone said that it worked fine, but I can't find the expected result. http://www.dsxchange.com/viewtopic.php?t=93466&highlight= There is a hierarchy of sequencers of which the main sequence call the subsequent sequences....

I have create a very simple routine only contain Call DSLogInfo("$APT_CONFIG_FILE", 'RoutineName') , but the output is string "$APT_CONFIG_FILE" Well ErrCode = DSSetParam(hJob1, "$DS_ENABLE_RESERVED_CHAR_CONVERT", "True") this is part of a job control code add...

It seems it can't be compiled with $TargetFileDir, "$" unexpected. Hi, why do you have # signs around the parameter name? Hi, I would like to pass environment variable $TargetFilePath into server routine. if i write this code, it is giving an error strFileLoc = DSGetParamInfo(DSJ.ME,"...

What kind of server routine do you use ? Before/After ? Where do you call the routine ? Before/After job routine or within Job Sequence ? Maybe you should add the env variable to Job properties first, and then code as #$env_var# in Before/After job routine, only $env_var in sequence routine activity...

Pass the environment variable to Input Argument Hi, I would like to pass environment variable $TargetFilePath into server routine. if i write this code, it is giving an error strFileLoc = DSGetParamInfo(DSJ.ME,"#$TargetFileDir#", DSJ.PARAMVALUE) Call DSLogInfo("strACRFileLoc :":s...

It is available in server routine, but buildops I havn't tested it yet Isn't it the same as in server jobs? For example Convert("abcdef", "xxxxxx", InLink.TheString) Ray, do you know if the convert function is also available in the buildops? We rarely, if ever, use Transforms, bu...

Have a try option "Number Of Readers Per Node" >= 2

Sequential stage 's processing will be much faster, but this no. depend on your server 's capability

ranga1970 wrote:Kumar is right I bilieve, sequential file can not be used in parrellism

thanks

try to Hash the input before joined Hi we use a Join Stage with inner join, the left link is a sequential file and the right link is a sequential file then a sort stage and a remove duplicates stage ,it should be output some records, but when we set two nodes in the configuration file, there have no...

In BuildOp "Properties Page", how can we setup this page to make our BuildOp stage similar to "Aggregator" stage, which properties, 1. Can always be found in "Available properties to add", no matter how many the same properties we have added before. (Similar to "Gr...

Besides, I have tried another method to do the similar thing as COBOL. Declare it as PIC 9(6)V9 COMP-3, then use Column_Export stage to export it as PIC X(4), and then use Column_Import stage to similar the redefine function, separate into PIC X(3) and PIC X(1), but when I browse the output in Hex f...

Arnd,

I am not quite understand your meaning, can u explain ?

If declare it as PIC 9(6) COMP-3, then it will be 4 bytes, but 12345 or 123456 only need 3 bytes

thanks a lot!

ArndW wrote:Use an unsigned and declare it as PIC 9(6) COMP-3; then ensure you put the leading zeroes into the string.

Arnd, do you mean packed no sign ? In my understanding, Packed no sign ------------------ 12345 ==> 135 24F Packed sign ------------------ +12345 ==> 135 24C -12345 ==> 135 24D I want ------------------ 12345 ==> 024 135 If you don't want the sign then declare as an unsigned COMP-3, but yes, the bas...

Seems DEADLOCK.MENU can solve this locks, right ? Jack_dcy, doing a UNIX kill is not a good idea in DataStage, especially if you let slip a kill -9 . Killing processes from the command line can leave locks hanging around that are not cleared (even with the uvdlockd running) and at worst might requir...

Try $DSHOME/bin/list_readu

jack_dcy wrote:Hi ,
we want to stop a running job at once. If we want to do this with killing this job's PID in the command line interface, but we can't find the PID of this job. What can we do?
By the way,we don't want to do this in Director.

Thanks!