DSXchange

Sorry for the confusion - bottomline is that I am unable to pass arguments to Wrapper Stage in desired format i.e.

Hi, I want to run an awk command from Wrapper stage. Something like awk -v x="~" -f #AwkScript# #InputFile# > #OutputFileName# I have selected "Value Only" as Conversion in the properties while creating the wrapper stage. I have also tried with Conversion as "None" Howe...

Hi All,

Does Datastage 9.1 support Oracle 8 database. Where can we find such information ? I glanced through few documents, but was not able to find the required information.

Thanks & Regards

Hi Ray,

It is not necessary that I use RCP, basically I need to use a generic job which calls routine on every column. Is there any such option.

Hi,

I want to create a generic job which executes routines for each field in the source with RCP enabled.

Is there any way to do this ?

Thanks

Hi there, I am reading from a sequential and I have a reject link from it, however would like to avoid warnings due to the rejects as I am already capturing them in the reject file. Can you please let me know how I could avoid those warnings (without message handlers). I have checked for options in ...

Hi You could try defining the first 500 as individual fields and then just leave the last 300 (or whatever) as an optional post-read parse. Could you tell me how we could specify " optional post-read parse ", because if I add any a field [varchar 300] after 500 bytes and then the job is dr...

Clarify something for grins - is the 500 layout a subset of the 800 or are they different? Meaning, are the first 500 the same between the two and one just carries an extra trailing 300? yes the 500 byte layout is a subset of 800 bye layout If you had something other than length to indicate the dif...

Hi,

I have to read a sequential file, which could be either 500 bytes or 800 bytes (either of them). All fields are char fields.

Is there a way to implement the above in a single datastage job such as specifying 800 bytes and specifying to check new line either at 500 or 800.

When I run the below query, I find only two default projects - ANALYZERPROJECT and dstage. However, we have more than these projects.

Can you please let me know I can have XMETA store the other projects ? I have OR Logging enabled through administrator (v9.1), still I am unable view the projects.

Hi All, I have a requirement where I need to perform replace of certain pattern in the entire string. For eg: +Type abc +Type def +Type ghi I want to replace this with: abc=Type-abc, def=Type-def, ghi=Type-ghi Do I have to go for a routine (or) is there a way that this could be implemented in a sing...

You could stage the incoming data onto a database. Write a query which joins this staging data to your DWH tables and unload only relevant data. You could add partial CDC functionality as well in your SQL query. How many millions of rows are you expecting. If your dimension tables are going to grow ...

You could query the DS_AUDIT table to obtain the list of jobs recently modified

try to include param values in double quotes

Note that the *.ds files will always differ from each other. Comparing those is pointless. Werner's approach will get you what you seek, or very close to it. ... Hi Ray, Can we have a job with run time column propagation enabled, with generic toolbox having orchestrate code for changecapture etc. w...