DSXchange

Visit www.tools4datastage.com and review the archives of this forum. Your issue has been discussed at length and you will find all the answers there. This archive is highly recommended to beginner DataStage people! Good luck! -Ken --- "Bhattacharya, Abhijit, ALINF" wrote: > Hello Everyone, > I creat...

Read the writeup on the "Command Line Interface" in the Server Job Developers Guide. Run, Reset and Validate seem to be the primary things you can do from a Unix command line, I dont believe you can compile from there. That doesnt mean you couldnt run a batch job from the command line that went in a...

Hello Everyone, I created and saved a Datastage job using Designer from my machine. But by accident my network connection went down. Now that my network is up, I am trying to access the job. But it keeps giving the following error message. Job job_name is being accessed by another user. Is there any...

Hi Everyone, Is there any way we can compile a job, Reset an aborted job from unix command prompt ? Please let us know. Thanks, Surendra This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed....

Tracy You can delete the duplicates with SQL. If you have Access then it has a find duplicates wizard. Use it to find them then view the SQL it created. The easiest way to to group by all the fields and write it into the new table. Another solution. With the SDK that comes with DataStage it has a co...

Greetings, My DataStage challenge du jour is essentially to correct a data model goof in a warehouses slowly changing dimension (SCD) table. The goof consisted of tracking certain data elements there that cause the table to lengthen far too rapidly, while adding very little analytical value. I am mo...

The data in a hash is stored in a dynamic array, not individual columns. A dynamic array is actually a single string with individual values delimited by specific byte values. If one of your special characters happens to be one of these byte values, it will be misinterpreted as a field separator, giv...

I determine this value because I insert these three DsLogInfo in the first step in my routine... Call DSLogInfo ("Len:":Len(Trim(FIELD1)) ,"ObtainInfo") Call DSLogInfo ("FIELD1:":FIELD1 ,"ObtainInfo") And I saw this : Len : 2 FIELD1 : 50 Ben "Ray Wurlod" cc: (bcc: Benoit Murray/MTL/DMR/CA) Subject: ...

We have/had a similar problem when trying to figure out if NLS was needed. The people at Ascential said it could just be a bug in the DS-viewer. What happends if you write the data back into DB2, are they still corrupt ? What is the hex values of the fields that goes wrong. I think it waf FA-FF that...

we do not have NLS installed regards Georges Daher Analyst Programmer Solutions Delivery Unit IT Department Banque AUDI S.A.L. Direct No : 977467 /Ext. : 1467 Fax : 961 1 980210 /Po.Box 11-2560 E-mail :Georges.Daher@audi.com.lb >>> tom.peter.nielsen@nordea.com Wednesday, November 13, 2002 10:23 >>> ...

Hi all, Im dumping data from DB2/400 into a hash file then from that hash into Oracle 8i. Some of the data in DB2 contains special characters, when inserting these data into the hash file the order of the data in the same record lose sequence, obviously when the order in the same record will change ...

I tested this about a month ago. To run multiple instances of a job, you append the instance id, which you have done. I have not tested it with batches, but there is no reason why this should not work (a batch is a job control routine with a funny name for its job). The error code DSJE.BADSTATE (-2)...

Listener and process metabroker must be started, then capture of process metadata into the MetaStage hub is automatic. There is a script for starting each of these processes; it is called StartService.bat (you find the one in the Listener folder and one in the Process MetaBroker folder). ----- Origi...

It really does depend on the format in which your metadata occurs in the Word document. You have to get it out of there. Chances are that its not in a format that either DataStage or MetaStage can deal with, however, though you do have a better chance with MetaStage. Without knowing the exact format...

Try re-compiling your routine. How did you determine that the value of Field1 is 50? (There is no way to provide NULL via the Test grid for Routines.) If re-compiling fails, can you please supply the remainder of the Routine code; I created a Routine with these arguments and it works fine. A tip: in...