DSXchange

Hi, Can anyone explain about PHANTOM?, because when i run the job, i am getting warning Phantom 933 and the message is "Program "JOB.1536909952.DT.1241937883.V0S26": Line 257, Variable previously undefined. Zero length string used. DataStage Phantom Finished" Thanks Joy _____________________________...

I updated this column on DS_JOBS and it still allowd me to save changes to a job. Im running DS 5.1 on Sun Solaris 8 regards, Peter -----Original Message----- From: Greg Smallhorn [mailto:greg_smallhorn@hotmail.com] Sent: Monday, 17 December 2001 8:27 PM To: datastage-users@oliver.com Subject: Re: S...

m is the main place. The manuals of most interest for DataStage error messages are: InterCall Developers Guide (InterCall is the architecture underlying UniObjects, the mechanism via which DataStage clients connect to server) Administering UniVerse (UniVerse is the origin of the DataStage engine) __...

For the benefit of those of us new to this list, and seeing as how there are no archives as of yet, can anyone provide the relevant URLs mentioned below? Thanks! -craig "Greg Smallhorn" cc: Subject: Re: phantom message 12/31/2001 07:05 AM Please respond to datastage-users [snip] Codes can be found i...

PHANTOM is DataStage terminology for "background process". The process that runs the job is a phantom, and other phantoms may be spawned to process each independent active stage in the job. Each phantom process keeps a record of its activity in the &PH& subdirectory, though these should be cleaned u...

Thank you , it works!! "Ewart-Phipps,Mark" wrote: > Hi Peggy > > It sounds like you have dirty data somewhere either NULLs or non > numeric data. Or, you have defined the input columns incorrectly. The > master file GPREM and the agent GPREM must have the same column > definition if possible or at l...

Whats the difference between the "Clear the table, then insert rows" and the "Replace existing rows completely" update action in the ODBC stage? The Help Book says : "Deletes the contents of the table and adds the new rows" for the 1st, "Deletes the existing rows, the adds the new rows to the table"...

I have a job similar to this. Every day I need to read a file whose name is the date (e.g. hisntt1.011226 is the file for 12/26/2001). The job control calls the shell script NYU_NTT_start.sh. This script checks for the file and then copies it to ntt.txt. The job control calls the Datastage job only ...

Celeste, You could probably use DS parameter for the file name. Leonid "Celeste Lim (COS-HO-IT)" on 12/27/2001 07:29:13 PM Please respond to To: datastage-users@oliver.com cc: Subject: Automate DS job Hi there! The scenario of the problem looks like this. I have a job that consists of UNIDATA stage ...

Hi there! The scenario of the problem looks like this. I have a job that consists of UNIDATA stage as source, a transformer and a Text file as the output. The problem is, there are a few UNIDATA files that need to be extracted and append to the same text file. Every time I need to change the UNIDATA...

In the WebCast for DataStage 5.1 it mentioned a new version control feature. I looked through the 5.1 manuals and the online help documentation but didnt see any mention of it. Any ideas where I can find out how to make use of this feature?

Thanks,

Scott

Hi Tina Your job is calling the routine FirstUpCase. Usually routines are called from derivations in transform stages. You may find it there. This routine produces an error. Improper data type in this case could mean thad the routine is forced to deal with a NULL value. Maybe you should enhance your...

Hi, I am running one ETL job which aborts with status 3 and gives the following message.Can any body help me in solving this problem? Regds Tina. DataStage Job 3 Phantom 760 Program "DSU.FirstUpCase": Line 11, Improper data type. Attempting to Cleanup after ABORT raised in stage CustomerFlattenedHRC...

Hi Peggy It sounds like you have dirty data somewhere either NULLs or non numeric data. Or, you have defined the input columns incorrectly. The master file GPREM and the agent GPREM must have the same column definition if possible or at least both should be defined as numeric. If the column definiti...

Hi there......... how can i add the GPREM form both source in transformer stages? i try to add both the attribute as DSLink5.GPREM + DSLink6.GPREM in transformer stage. It shown the following error message when i try to run the job Data Stage Job 91 Phantom 2056 Program "JOB.875852342.DT.1240954370....