DSXchange

Still I dont think its possible to use CALL DSExecute.... in shell script. Unless other wise the whole statement is passed as a parameter to a job that been called inside the shell.

What happend to the page alignment?
As mentioned, you can check the process that keep track on the given table from the database end. Your DBA might help you to kill those process. But you may need to check if this repeats again for other tables as well.

What happend to the page alignment?
As mentioned, you can check the process that keep track on the given table from the database end. Your DBA might help you to kill those process. But you may need to check if this repeats again for other tables as well.

As Ray mentioned, CALL DSExecute("UNIX",Cmd,OsOutput,OsStatus) you are using BASIC code in shell script. And calling the script from Execute command activity. Either you need to create a BASIC routine to do this or you need to create a shell script which has db2 CONNECT TO database USER userID USING...

I guess the requirement is same as your other post. http://www.dsxchange.com/viewtopic.php? ... highlight=

Or as mentioned, google for the C code. http://www.planet-source-code.com/vb/sc ... 0&lngWId=3

How about if you input is "ABCXYZABCA" Even if the A that present in the last need to be convert to the corresponding caracter decode value, Convert() as mentioned by DSguru2B will be suitable. I wish there should be a way to count the total number of presence of the substring using Count() and loop...

Hi Munish, You are doing a transformation by doing a Trim. Lookup stage is build for doing a Lookup. So if you had a quick look into the pdf that are available in you PC Start--.All Programs-->Ascential Datastage-->Online manuals, you can easily identify that there are some other stages like Transfo...

What is the job design? What is the transformation that you are using in transformer? Possibly you might be using some substring and you might have assigned the resultant to a integer field. Where as the actual result is apprering as character/varchar. If you make a search, you can find many topics ...

You can assign the condition check in the derivation of the stage variable. And the same variable can be used for constraints. The stage variable is not mandate, just for better understandability. Once you created a constraints, those rows that doesn't match to the given constraints will be rejected...

You need to give * character to the length of the field.

It is same as the other stages. If you sort the data, and the if you wish the order of the data within a group be the same (based) on the key mentioned, you can select this option. Yes, it will be a overhead. Its an additional process to trace the position of the rows in order.

I still dont get the exact question. In job1 a Aggregator been used and Sum(Sal) is calculated. In next job (Job2) the output of Job1 is used. What is the need to add a new column. If the output is aggregated, the sum(sal) will be available as one of the field. Or if you want to add sum(sal) for cer...

I dont have access to PX right no, but you can try using the Condition option available in Lookup stage.

Alternatively BASIC Transformer can also be used in PX job for the same reason. Or the rowcount can be written into a Sequential file, and Execute command activity can be used to read and pass it as a variable.