DSXchange

[quote="DSguru2B"]Do a sparse lookup, ping the sequence object and get the next key. Then save it, use it, do whatever you have to. I do something similar in db2.[/quote] I need to get the nextval and join it with every row of an input file, in other words, each row of the input file needs...

I need to get a sequence number from an Oracle sequence to use in my job. I can modify the insert/update statement in an Oracle stage to insert a sequence number, but I need that number in other stages (we are populating many tables with the same sequence number). I need to use the sequence instead ...

I used Administrator to create a vrbl: RUN_DATE with value of "2008-06-06" In the job transformer, in a field defined as: VarChar 10 In the field, I used the derivation editor to select: Job Parameter. $RUN_DATE is in the list, which I then select. So, I end up with $RUN_DATE in the deriva...

[quote="ray.wurlod"]A Join does not generate any "rejects", either in SQL or in DataStage.[/quote] Ab Initio does though!

I am importing from a lot of DCLGEN files. Each one works great, if input separately. But if I concatenate them all into a single file, then the importer only recognizes the first table definition. Each of the separate files contains both a DCLGEN and a COBOL defintion. So, I tried to load the multi...

[quote="ArndW"]That behaviour makes more sense, since the "load" option executes externally to the DataStage. If you don't use the load method you will probably see the job execute as you expect.[/quote] I'm not sure I know what you mean by "'load' option." Settings wit...

[quote="ArndW"]That is strange behaviour; you mean that you have "reject" enabled in your Oracle Enterprise stage and you have a reject link going out of the stage and you still have records that disappear on write - ending up neither in the table nor in the reject link?[/quote] ...

I have an ETL job in which the destination stage is Oracle Enterprise (OE). There is a reject stage and reject link associated with the OE stage. My intent is that records which, for any reason, fail constraint checks within the Oracle table fall into the reject file. This concept works when key con...

We have DStage Enterprise Edition (server) running in large production environment on 64-bit Linux RH 4.5 VMs

New Linux RH 4.5 64-bit install of Dstage Ent Edition. Could not compile jobs because by default DStage tries to use 64-bit libraries. DStage must use 32-bit b/c it is a 32-bit application. Error: Error when checking composite operator: Subprocess command failed with exit status 256. Error when chec...

Migrating from Solaris to Linux RH4.5. Solaris install is configured to authenticate using PAM and all user groups are defined using LDAP. PAM is enabled. Running successfully. When configuring on Linux RH4.5 I am getting an "invalid user" error and the client cannot connect. All user grou...

It worked.
Thanks.
Incidently, the documention Designer Manual, page 9-13 is wrong. It does not explain to use Plug-in Data Defintions.

Thanks
-- john herr
Lockheed Martin

It worked.
Thanks.
Incidently, the documention Designer Manual, page 9-13 is wrong. It does explain to use Plug-in Data Defintions.

Thanks
-- john herr
Lockheed Martin

How do you point to an actual table instance from (where)?

-- john

I'm trying to build a table definition. My input is from an Oracle DDL file: create table abc ( field1 varchar(10), field2 varchar(10) ); If I convert this to a sequential file, how would it look? And do I use a ".TXT" suffix on the file name? Does the input file get read from the server o...