DSXchange

Try this in the Command window of the Administrator or in a telnet session to the DataStage Engine in the project directory. Be careful with casing, and with choosing the quotes correctly (single or double quotes). Hint: Display this message in a non-proportional font, such as Courier New. SELECT OB...

This is a topic for an orphaned message.

> -----Original Message----- > From: pavan.marpaka@ascentialsoftware.com > [SMTP:pavan.marpaka@ascentialsoftware.com] > Sent: Thursday, May 09, 2002 5:22 PM > To: SHailey@CSCUS.JNJ.com > Subject: RE: DataStage Digest Files created for a job > > Sure no problem.. > > Bascially, when you create a data...

Yes and no. If by "the documentation" you mean that which ships with DataStage, you will find a CLEARFILE statement and a DATA statement in the BASIC reference manual. Otherwise you need to get the appropriate UniVerse manual from m. In this case, the appropriate UniVerse manual is UniVerse User Ref...

Thanks, that works. Youre right I did not copy the second command correctly. Is there any reference in the documentation to: CLEAR.FILE or the DATA statment as you mentioned previously ? Peter -----Original Message----- From: Raymond Wurlod [mailto:wurlodr@au1.ibm.com] Sent: Monday, 13 May 2002 12:0...

Ahh, yes! Even though there are non-numeric values in the column, the @ID columns reported data type is numeric (INTEGER) because it is specified as right-justified in the file dictionary. You need a CAST function to treat the column temporarily as a character (non-numeric) data type for the SQL sol...

Ray, Im getting an error when running either command: "The LIKE operator may only be used with character data." This is with DS 5.1 on Solaris. Peter -----Original Message----- From: Raymond Wurlod [mailto:wurlodr@au1.ibm.com] Sent: Saturday, 11 May 2002 8:12 AM To: datastage-users@oliver.com Subjec...

Can you please provide more information on exactly how your job control is creating - or attempting to create - hashed files? Can you also determine the value of the T30FILES configuration parameter (this is a ceiling on the number of simultaneously open dynamic hashed files)? Ray Wurlod Trainer, As...

A very comman occurance is that file structures and directories need to be identical as they are embedded in the project. You may want to check to make sure this is the case. Tracy Slack wrote: > Hi, > > Our team has developed a project under v4.1 DataStage on Win2000, and > have had it working for ...

Hi, Our team has developed a project under v4.1 DataStage on Win2000, and have had it working for months, user-defined routines and transforms and all. I am now installing newer v5.1 on a new Win2000 server, have imported a .DSX (full project export from v4.1), compiled each routine and job, release...

There are control records (with non-numeric keys) in the RT_LOGmm files. CLEAR.FILE will destroy these. Its better, though slower, to delete only the records with numeric keys. For example: DELETE FROM RT_LOGnn WHERE @ID NOT LIKE /%; or SELECT RT_LOGmm WITH @ID LIKE "1N0N" DELETE RT_LOGnn respond "Y...

Has anyone found a way to extract information on transformations of a field so that the logic could be checked by the business segment that needed the data? The DataStage documentation tool does not give all the data needed or it is too cumbersome to find. What would be nice is a report of the follo...

What is the correct way to clear log files using a DS routine ? Im currently excuting: CLEAR.FILE RT_LOGXX - where XX is the job number extracted using another routine. Should I be clearing all records from the RT_LOGXX file or am I risking corruption ? Im running DS 5.1 on Solaris 8. regards, Peter...

Hi Hailey, Could you forward the email I sent you regarding DS_JOBOBJECTS. I didnt realize I wasnt sending it to the group. Thanks PKM -----Original Message----- From: riccardo.tani To: datastage-users@oliver.com Sent: 5/9/2002 5:17 PM Subject: Re: DataStage-users Digest 9 May 2002 00:00:01 -0000 Is...

This is a topic for an orphaned message.