DSXchange

HI Srini, do you want to know, how to use to columns in derivation in an output tab? I couldnt understand How to specify two input columns ( syntax) in the "derivation" . Please elaborate on this. If you want to use two columns coming from input in an output tab, you can use them as column...

Hi All, I have recently prepered a DSJob to get log that takes input as file name. this Input file contains list of job names for those log is required. After running this job. It creates a text file containinng jobname, stagename, no. of rows (in as well as out) and time elapsed. If you wish I wont...

Link doesnt work. Shows blank page.

ohh....it was very simple.thank you very much. I didnt try this at all, I just followed instruction of Datastage Help and caught in mess.

Thanks again.

Girish Oak

Hi, I am trying to get multiple rows usign uv odbc lookup stage. As per the help given by datastgae, I tried to search "reference link with multi row result set " checkbox option. I clicked number of times on the header of link, but it never showed me this option. Can anybody tell me how t...

Hallo, I am facing a very strange problem while using OraaBulk stage. In a server type job, I am using simple data file to read data. I am giving the out of my sequential stage to OraBulk stage through a transformer. I am doing nothing in transformer stage, it is very straigth mapping of columns, no...

Hi, I have created a datastage job that uses Informix Stage to extract data from Informix database. It is pretty simple job. nothing special logic has been included in that. When I run this job, in director it shows status as Running, but if you see the same job in Designer using view performance op...

Hi Ray, Thanks for your reply. I have found out some solution similar on your lines. I have created shell script which takes parameters for source table and target table and I am using simple sqlcommand Insert into tablename1 Select * from table name2 I think the solution what you have given is diff...

Hi Ken,

Can't we load table defination on the fly in oracle Stage. Also, I was looking for "work around in datastage".

Looking for response.
Girish Oak

One more thing to add is "I dont need any expression in between"

Thanks Ray for your reply. Few things probably missed out are as follows : 1.Table definations are stored in my repository. 2. Source Tables and Target have same metadata. 3. I want to create a single job and want to run that with different instances. I want to attach this meta data to the stage on ...

Hi All, I tried to search something similar, I am looking for. Basically, I want to create a generic extraction job that can extract data from given table. I want to use only 5 parameters such as OracleDSN, OracleUser, OraclePassword, TableName(by which data is to be extracted), TableName(where data...

Hi,

can any body please tell me how to run a job with multiple instances using DSRunJob

The question was raised in the forum earlier by any other person,but no one have replied to this.

Thanks in advance.

Girish Oak

Thanks Ken for your idea.

Hi, I have source file which contains 13 columns. In that last 11 columns contains rates for year 1 to 11. I want to create 11 records from one line. For that I have written following routine. But while testing itself it hangs the routine. I think it hangs while opening or reading the file. Can any ...