DSXchange

No luck, still I get the same error, with password enclosed in double quotes, i.e "team#234"

I am trying to connect to Oracle Database using a Password "team#234". When I tried to View data in Oracle Stage, it throwed "Incorrect dboption list; it failed on Expected "," or "}", got: "#", line 1." I searched the forum and found the below http:...

Let me explain in other way I have the hashed file "Hash_Latest" which gets populated using 5 key column and 1 non-key column. There are 2 jobs Job 1 The hashed file(with 4 key columns and 1 non-key column) is used as lookup in transformer . Source(stream) is Oracle Database. In this case ...

While populating Hashed file, it is populated wuth 5 keys, but while reading it is read with 4 keys only. I got resolution but not convinced with the behaviour of the Hashed File. While reading from the hashed file, I used all 5 keys, the lookup worked and the records came out from transformer. But...

I used the same Hash File as Source and the actual source as lookup .In this case lookup is satifying. i,e I could see records in the reference link.

Strange, I am not sure what's happening.

Sorry for wrong terminology.Let me explain the issue clearly. Actually I am using the Hashed File as lookup in Job B. If lookup satisfies, records would flow from the output link of the transformer. For valid lookup match, there should be records flowing through the output link of the transformer. I...

I am using a HashFile "Hash_Latest" which has 6 columns. This hash file is populated in one job A and used in another job B . In Job B, this hash file is used as a Look Up. When I View the data in Hash file by using View "Hash_Latest" data, I could see two records in both Job A a...

Hi, you don't "Have" to write routines... Just proper use of the transformer (Stage variables and the "if... then... else..." statement in the derivations) can get what you want. Could anyone explain the steps involved in above Hi Keshav i wrote a VB macro to create a scema file ...

Kathik, I am also having a similar issue. I tried using the schema file as a parameter for the sequential file stage(which is the source) and it works perfectly. The problem starts when i try to parameterise the target table, as i dont see any option to use a schema file in any of the DBMS stages. T...

run time column propogation................... RPC or use schema files to input metadata definition to the jobs. it worked for me Is it that for each source file metadata structure, should we have a separate schema file?If so, how could we determine in runtime that a specific schema file has to be ...

I am in a situation to find out who did an import of a dsx file to a project.
We do not use indiviudal user logins for datastage.

Is there a way to find out the machine name or ipaddress or network login from which import has been done.

Possibly not, however, since it's notoriously difficult to run a BAT file on a UNIX system. The logic could be converted into a UNIX shell script however, and one would need dsexport to be available on the server machine. Does this mean the Script that has been posted by DW_USER can not be run on a...

You wouldn't call the Manager but rather dscmdexport.exe for an entire project or dsexport.exe for a single job. This command will work for exporting just one job. If I have 20 jobs to export, is there any way I can put all these 20 jobs in a file and then pass this file as input to dsexport.exe wh...

chulett wrote:The 'DS Manager' is a client tool. Windows, not UNIX.

Thanks. In that case, is there any command in Windows which we can put in Bat file which will call DS Manager and take the export of jobs using the input file containing all the jobs?

Hi,

Is there any command in DS where I can export the jobs using UNIX, say call DS Manager from Unix shell script and then pass all the job names to DS Manager using a file and a dsx will automatically be created based on the input file having all the jobs to be exported.