DSXchange

Now that there are potentially five different job types in DataStage, it is time to make a plea for posters not only to specify DataStage version and operating system, but also job type (for example, server, parallel, mainframe, job sequence or shared container). This will help eliminate incorrect r...

Hi all, Does anyone know how i can generate surogate keys from PX. when the data already has data in the table. let me explain better. I have a table A. with an id of 1 to 100 already. How do i generate a new sequence that will be on going (101,102) without it re_initializing whenever i restart the ...

Pls disregard my last mail. I found it. thanks -----Original Message----- From: Tony Curcio [mailto:tonycurcio@yahoo.com] Sent: Wednesday, July 09, 2003 4:13 PM To: datastage-users@oliver.com Subject: Re: Error Message In this situation you need to go to the Edit Column metadata tab in your file sta...

Hi Tony, I did look into the file stage but could not locate where the "Null Field Value" Property is set. Could you pls re_direct me? or if anyone else knows. Tunde -----Original Message----- From: Tony Curcio [mailto:tonycurcio@yahoo.com] Sent: Wednesday, July 09, 2003 4:13 PM To: datastage-users@...

Hi, Im getting the error as writen in the subject field... any one knows what the problem might be? Thanks! Wim van Dommelen. -----Oorspronkelijk bericht----- Van: Tony Curcio [mailto:tonycurcio@yahoo.com] Verzonden: woensdag 9 juli 2003 23:13 Aan: datastage-users@oliver.com Onderwerp: Re: Error Mes...

In this situation you need to go to the Edit Column metadata tab in your file stage and add the "null field value" property. I normally set this to a set of spaces to match the output field length. The reason you get this error is that PX doesnt make an assumption about how a null should look in a s...

Hi all,
Do you guys know how i can resolve this errors?

Sequential_File_10.DSLink14: When checking operator: When validating export schema: At field "ACCT_EXTV_I": Exporting nullable field without null handling properties

Read docs, however here is a basic sample to get you started insert your ip address #!/bin/ksh #example is on solaris v 6.0 print "starting $0" jobname=$1 projname=$2 execpath="/appl/dsadm/Ascential/DataStage/DSEngine" print "PREPARING TO run $jobname in projname" $execpath/bin/dsjob -server 1.10.12...

We are doing the same thing with chared containers, both in version 5.2 and now in version 6 We use shared containers as components, to make re-use and impact analysis a lot easier - and also keeping the visual benefit instead of using routines. What we do is that we send the columns to the shared c...

It is located in the Server job manual. On page 636 in version 6.0r3 DataStage Development Kit (Job Control Interfaces) -> Command Line Interface - Tom -------------------------------------------------------- Tom P. Nielsen Project Masterdata & Transformation Reg.nr. 5486 / CB T400 Nordea Bank Denma...

Hi, I want to start a DataStage job from the unxi shell, I think I have to use ds_job_run but I cant find any documentation about this. Anyone knows how to do this and what the paramaters for this call are? Thanks. Wim van Dommelen. ****************************DISCLAIMER*****************************...

Reference lookups are driven from a Transformer stage. On the link that is performing the reference lookup you specify each column involved in the WHERE clause to be a key column. If doesnt matter whether it truly is a key. What this will cause to happen is that you need to enter a "reference key ex...

Yes - you certainly can use a single column in multiple (simultaneous) lookups. -craig "Sodhi Arvind - Princeton" 07/08/2003 08:48 AM Please respond to To cc Subject RE: remerging rows. When using 1 flat file and multiple lookup hash files, can the same column in the flat file be a part of multiple ...

When using 1 flat file and multiple lookup hash files, can the same column in the flat file be a part of multiple keys on which the hash files will be looked up? To explain further, say col1, col2, col3 of the flat file need to be replaced by a value from hash file 1, and col2, col4, col5 of the fla...

Many Thanks to all who replied. I will try it next time in a test area and post my results. Thanks again Regards Gopal =========================================================================== IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confiden...