DSXchange

Athira, start with a very simple job, just your data source to a transform and output to a dummy sequential file. Get this working. Then add one reference lookup and get that working (again to the dummy output file). Finally add your last reference, and once that is working to your satisfaction fina...

Bollenik - most likely you are using a multi-node configuration and not accounting for how PX works. If you change to a 1-node configuration do you get the results you are looking for?

Odd, I did an exact match on "open failed: No such file or directory" and got 30 hits, including numerous posts with explanations by some experts here in the forum on probable causes.

did you put an explicit CAST on your SQL to convert it?

Could it be SMEagol you are looking at? If so, it is a common medical condition affecting DataStage developers that, over time, tends to eliminate them from the gene pool. It is caused by lack of daylight and by crooning over DS jobs (sometimes accompanied by chants of "there, my lovely" when compil...

good one!

When did the consultant present his invoice for 6 billable hours?

What database and stage are you using? To rephrase your question, you have a column called "TIME_STAMP" in a table. You've loaded that table's metadata into DataStage and have used that in a database stage. When you do a "view data" on that table you get the error that the column "TIME_STAMP" doesn'...

Did you not post this exact same question earlier? Also, I'll chime in before someone else does regarding the use of "urgent". What is urgent for you is not necessarily so for the volunteer members of this forum. You normally need a pricey service contract from your provider to get immediate replies...

as far as I know, vargraphic isn't supported. Can you cast it to charchar in your select and then declare it as varchar in the job?

Probably space. Can you monitor your scratch directory as specified by your active APT_CONFIG file? How long after you start the job does this happen?

I looked in the docs and didn't find a function, either. Odd.

Try AsInteger(StringToDecimal(In.Column))

If you simplify your job to the 2 Oracle stages, the join stage and then a peek stage, does the error still happen?

In that case you should write a "master" sequence which calls the first job/sequence without waiting. I see two ways to do this for you: 1 - use the command to run "dsjob -run -mode normal {job} {project}" 2 - use a job activity to start the job in a sequence. Then look at the job control for the BA...

Can you narrow down the causes? Does the error happen right away or after a while and processing n-rows? If so, does it always fail on the same row? Which stage do you replace with a lookup stage (and what are you looking up - another table)? Have you tried changing the job to run on just 1 node to ...

I'm not sure why you can't work around the issue of waiting for the job to finish in the sequence, but yes, you can call a command stage and issue the appropriate "dsjob -run" command from a sequence.