DSXchange

I don't know a way to *really* use several delimiters in one sequential file stage. But perhaps you can cope with this by using a Filter in the sequential file stage. Here you can define a filter program that for example would change all pipebars in the file into end-characters, so instead of two de...

Perhaps more a workaround than a solution... You can choose the execution action for Job Activities in a Sequence. This drop down box gives you the option to (for example) just validate the job instead of running it. Another option is to just make the sequence more intelligent (=more complex), by ad...

Seems like I just answered a very similar post. viewtopic.php?t=128756

By the way, please give your questions a subject that's a bit more descriptive.

If the number of 'columns' in the field EMP_SKILLS is not very high you can achieve your goal within a normal Transform-stage by using the field-function. - Make as many outpulinks as the maximum number of 'columns' you need to extract from the field EMP_FIELDS. - Output the necessary columns and th...

but I see no way in using that in the Filename property. Why can't you use in file name ? apart from the business reasons. ... According to the Help (under Defining Hashed File Input Data ) you can use macros in the file name property, which in thought you couldn't. Quote: The name of the file the ...

Sainath.Srinivasan wrote:You can create the hashed file with a parameter value as its name. ...

So just add a parameter with the invocation-id in the job and use that in the filename.

You can also extract the invocation-id in a job from DSJobname, but I see no way in using that in the Filename property.

To me this desciption is a bit different from the example in your OP. In your first post the result will not just have a different number of records, but it contains different columns: COMPANY instead of VENDOR. Have you tried, as priyadarshikunal suggests, to run these queries directly in DB2? That...

priyadarshikunal wrote: No. Both ways are equivalent.

Yes I figured that out myself and already had removed most of my post

An alternative approach might be, steering away from parameterized SAL and towards DataStage-functionality, to use a sequence in which you use a UserVariables-Activity. You can use an if-function here to 'calculate' the correct SQL based on your parameter and then insert the value of this variable i...