DSXchange

Is anyone running code generated with any version of DataStage XE/390 with DB2 v7.x? My understanding from Ascential is that they have not completed testing (of any version). The belief is that any existing code running with DB2 v6.x will also run with v7.x but will not be able to take advantage of ...

Im a new DataStage user with lots of questions. We are running DSXE v5.2 on an NT server. I have a job sequence comprised of seven jobs and two sequencers which can be run for any one of our five divisions, using specific parameters for each division. Briefly, the jobs extract data from Datacom data...

Thanks a lot!! Ugo > In your Job > > > Select EDIT, then in the BEFORE JOB category, > Select TCL, then in the right side, type: "Clear.File {filename}" > > that should clear the HASH file before the job begins processing any > data. > > Again, if you are moving data into the HashFile Stage, you can...

In your Job Select EDIT, then in the BEFORE JOB category, Select TCL, then in the right side, type: "Clear.File {filename}" that should clear the HASH file before the job begins processing any data. Again, if you are moving data into the HashFile Stage, you can also clear it at that level. simply se...

Thanks for yuor answer, but how can I enter in the uv command line? Thanks Ugo Mascetti > command: clear.file {filename} at the universe command line level > or in the hashfile stage, there is a radio button for Clear File > > in the "Before Job" process you can also issue a "Clear file" command ( >...

command: clear.file {filename} at the universe command line level or in the hashfile stage, there is a radio button for Clear File in the "Before Job" process you can also issue a "Clear file" command ( above) to clean out the hash file. OR if the hashfile is being populated by a transform, simply s...

Dear all,
how can i clean (not drop) an hash file?
I have created it by an hash stage and I want to clean it for the next
execution.
It is also possible clean it with a CLI command?
Thanks,
Ugo Mascetti

Hi Giovanni, Could the NULL be for a column which is not mentioned in your Insert statement? Regards - Chris Thornton -----Original Message----- From: Giovanni Boccia [mailto:giovanni.boccia@datamat.it] Sent: 29 June 2002 09:22 To: datastage-users@oliver.com Subject: ORA-01400: cannot insert NULL in...

There IS a BASIC guide out there. m However, this does not explain the query languages available. Separate manuals exist for these. m m There is no command per se to list all hash files in a project. One possibility is to use Manager to Import UniVerse File Definitions, which will produce a list of ...

Hi All!

Since there is no Basic Guide available out there...I am asking you this simple question:

Whats the CLI command to list all hash files in a specific project?

Thanks

Christian

If the Oracle table is the source and the hash table is the lookup, constrain the output with an isnull(lookupkey). There is essentially a LEFT OUTER JOIN (in SQL syntax) between any source and lookup in a transformer. That constraint will pass every row that has no matching key in the lookup. A FUL...

Hi Ugo, use a constraint in the outputlink. For example if O_ID is the field in the Input-Oracle-Table and H_ID the field in the Hash-Reference-Table which you join for reference then the constraint could be "ISNULL(H_ID)". By this only rows from your Input-Oracle-Table, which have no reference in t...

Dear All, I have a table (Oracle) that has a link to a transformer. There is an Hash file that has a reference link to the same transformer. I want (in output from the transformer) all the rows from the table that DO NOT match any key in the reference link. (A sort of NOT EXIST between two oracle ta...

The commands can be found in the Server Job Developers Guide. Have a look under BASIC Programming - BASIC functions and statements - Sequential File Processing. The commands are very easy to use, OpenSeq and CloseSeq open and close the file, ReadSeq and WriteSeq read and write to the file. There are...

Kenneth, could you send me the surrogate key assignment routine youre talking about in your answer. Thank you, Kasia At 03:50 17/05/2002, you wrote: >Patricia, what you really need to do is seed the >DataStage job with the max surrogate value in the >table. The job can then use that seed value and >...