DSXchange

If your data volume today is close to before then perhaps the create error message has to do with Unix file permissions. I'd suggest that you verify that the login you are using has the correct Unix permissions to create/modify the hashed data file (and/or its directory location). If your permission...

It appears that your source data can have several different formats but basically representing two separate fields. I'd suggest that you create a simple DS routine that uses the MATCH[ES] command in a case structure. If the extraneous spaces are not required for the output then I'd first Trim the st...

In either version of Datastage (Server or EE), you cannot open the same sequential or dataset file for both read and write. The only file type that you can do this with is a hash data file.

Hiten,

You need to set a variable to the Unix command you wish to execute and then use this variable in the DSExecute funtion.

Cmd = 'grep ':Filename:' ':Pathname
Call DSExecute('UNIX',Cmd,Output,SystemReturnCode)

I can think of a couple of ways to accomplish your string extraction: 1) If you know that your data will always have the "_20060913.csv" at the end, you can simply do a the following in your derivation: link.columnname[1,Len(link.columnname)-13] This approach will always work no matter whi...

Probably the simplest means of accomplishing the extraction of one or the other values is to create a simply Datastage Transform that has three visible arguments: DataToParse (actual data value), Delimiter (such as space), and ValueToReturn (integer value 1,2,3, etc. to indicate which value you want...