DSXchange

Hi, Just i am creating some hash files from the table. The source is MS-OLEDB. It ran fine before and now it is giving the same error once again. For some 3-4 hash files, it is not populating data. For other hash files, it is populating. I used only one OLEDB stage and only one hash file stage with ...

Hi,

The job is aborted by giving the fatal error as

GSAP_LOOKUP_CreateLkpForFormatJobs..SrcLookUpTbl: COM Initialization failed.
COM Initialization failed.

What might be the cause? Did anyone got this error?


Thx in Advance

VC

Hi, Is there any way to provide some Alert/ Meaningful Message if the job gets aborted?? I need to capture the Aborted Log and i want to create some Alert/ Meaningful message. My job is aborting as i couldnot able to read my input sequential file. The file is coming with a bad data and the job is ab...

Sounds like you haven't actually given the Sequential stage a Filename to use and it is still defaulted to the Link Name. Which means it is trying to create it in the current Project and you don't have permissions to create it there... probably because it already exists there. My guess, anyways. Ho...

These aren't normal 'phantom style' errors - as a matter of fact they don't seem to be errors at all. I would think that you are using a routine or some piece of custom code that has debugging statements left in it - PRINT statements, for example - that are 'logging' information when the routine is...

Hi Chullet,

You might be correct , i am using routines in my job...and i think i have included such degugging statements...


Thanks
Vc

Hi All,

When i pass data from a transformer to Sequential file in one of my job, i am getting one error : Unable to create Linkname , say, DSLink4|.
Can anyone of you have experienced this same error, pls reply..


Thx in adv

Vc

Hi All, We are getting datastage phantom error whenever we run a job having stage variables and parameters.The job finishes without any error but only with warnings.Can anyone of you please tell how to avoid this phatom errors. One sample Warning error log entry is : DataStage Job 532 Phantom 8620 2...

we are using one routine for that....In that routine we will use the transform DSGetLinkInfo


Thanks

Vc

Hi,
Anybody of you have idea about DSJ.INSTROWCOUNT?If so help me out ASAP

Thanks in advance
Vc

Hi All,

The job has an Inbound Sequential File connected to a Transformer. It needs to find the number of records in the file. If the file is empty i.e the number of rows is 0, I am not able to fetch the count and use for other validations.

Thanking you in advance
Vc

Hi All,

While running datastage jobs i am getting "datastage phantom error "(plus one number like 10188) frequently.One example is given-
"DataStage Job 532 Phantom 10188". The job finishes but with warning.
Can anyone of you help me ?

Thanks in advance

Actually what i need is , i have to get the same sequential file without the first record through routine only , not by datastage job.So skipping , i think ,doesnt suit.I got one basic command called delete.Its syntax is like DELETE [file.variable,] record.ID THEN....ELSE... like that. But what is t...

Can anyone of you tell me how i can delete first record from a sequential file through datastage routine.Is there any command like openseq or readseq for this processing?

I am getting a fatal error when i run one job named 'Row out of sequence'.Actually in this job, data is flowing from a sequential file to an aggregator.Totally 7 rows are going through that link.The Error message is : Aggregator_132: Row out of sequence At row 5, link "DSLink133" Row out o...