DSXchange

Well, it's been a long time since I replied to anything on here, but I just had to do this myself, and I'm in the same boat. Basically, I had a flat file source, and an Oracle table used in the lookup. Well, since the Oracle stage doesn't allow you to return multiple key matches in a lookup, we had ...

Rebuild your Job Sequence from scratch, and see if it give you the same error. Is anyone of the jobs renamed or missing, i think its not abel to attach the job. Can you please post the complete error message. Hi The jobs are not renamed neither they are missing. And the error we got is what i alread...

psriva wrote:I am on the grid. (Not windows.)

You can either use an Execute Command in the Job Sequence, or you can go into your job parameters, and execute the unix script either as a pre- or post-command.

TAZ

We're running DataStage 7.5a in a AIX box with multiple processors. Now that I got that out of the way, my question: Is there a limitation in DataStage on the number of SAS stages in a particular job. We have a job that has 36 SAS stages, and when we added the 37th stage, the job aborts. The job run...

Is there any kind of Overhead or Advantages in FTPing file through datastage rather than FTPing manually or through other processes? Just want to have some information regarding this. Thanks sam The only advantage I could think of would be that you could ftp the file into whatever format you needed...

kumar_s wrote:Perhaps you may ask the issues or doubts you have, so that you may get the answer?

Ok, my question is CoSORT says their product works with DataStage Server Edition, so I was wondering if anyone had used it with Enterprise Edition. I didn't know if it was possible.

Thanks.

Anyone use CoSORT products in conjunction with DataStage Enterprise Edition?

Thanks,
Jason

jason, Is there any alternate way to achieve this without using shell scripts? i need to run the jobs from jobsequencer.. At run time, aren't you prompted to populate the parameter you defined? If not, you'll need to add it to your sequence job parameters, and then right click on each job in your s...

Thanks kumar for your quick response! what I want is: Can I change/update the value of the job parameter within the same job. Before job : Paramter X holds the value "1" After job : Parameter X has to be changed/updated to "2" how can i achieve this? I would say pass Parameter X...

I would just use unix cron command and set it up to execute a korn shell script that looks for the file.

Jason

You can also log into DataStage Manager, and go to Tools...DataSet Management, and find your DataSet. This will give you the size of that DataSet.

Thanks,
Jason

This is the last message I receive on my log before it hangs: SUPRS_DTL_LOAD_TBL: Calling APT_DBExportOperator in SUPRS_DTL_LOAD_TBL::reportInputAttachment() The next entry in the log is 5 or 7 min later, when sqlloader starts the load. SUPRS_DTL_LOAD_TBL: Returning from APT_DBExportOperator in SUPR...

Hi, I'm a newbie to this forum, but I've been working with DataStage for over 3 years. Now, to my issue. We've been running in production for 2.5 years, with very few "issues" that we couldn't solve. Well, I've finally come across one. I have a process flow that reads in a sequential file ...

Well, you have a couple of options. You can use the crontab command in unix to create a cronjob that in turn kicks off your dsjob script and executes your DataStage sequence. Or, you can actually go into DataStage Director and click on the schedule job button. I find that the cronjob works better. I...

Ideally, you'd want to install the 7.5.1a on a "test" box. Export and import your existing flows on the test box, and run several tests. Once you've been satisfied with the test results, you can just install the new version on your "production" box.

Thanks,
Jason