DSXchange

There are two ways I know of.. 1. Open each job in designer and generate report.. 2. Use command dsdesign.exe through the parameters and generate the report. We can automate the second one, except if we come to know all the job names in a file, which we can supply as jobname parameter to dsdesign.ex...

HI Would like to get documentation reports for all the jobs in a project in a faster way.. How can I do that? Actully, I can generate the documentation report for each job seperately in Administrator.. But to generate reports for 100's of jobs in a project..in a faster way... I need a best solution....

Hi


Can you please help me in resolving DB connectivity problem from DataStage..

Thanks
Sai

Thanks Chullet.. I got it.. It is working fine ..when I rebuild it... Thank you.. I didnt follow your note correctly..

Coming back to the main thread issue, whats the reason behind "not able to connect to db from datastage"

Thank you and Thanks a lot
Sai

Hey chullet

I made it wrong...
What could be the solution now.. As it is production.

Hi Ray.. The import table definition also not working.. But i could connect to oracle from the linux host server where DS installed.. I tried "Rebuild Indexes" from DS Administrator. And restarted DS Server.. But shockingly after the restart, all my DS jobs in the projects are unvisible,.....

Hi Suddenly in our production, we faced the following problem. All the database stages, i.e. Oracle stages not working and not connecting to the DB to get data or call procs. To verify this, i have designed simple job, which pulls one row and writes to a file, even this job is also not working. Here...

hI PhilHibbs It could be non-ascii file... we get this from an upstream system as a regular file. Please dont concentrate on the type of file, instead can you please tell us, if possible, the problem with the non-conversion of chinese characters using UTF8? As it is working fine with normal sql load...

It is ASCII file, which contains Chinese characters. But could not load using DataStage.. But could load correctly using SQLLOADER.. I tried setting UTF, ISO8859-1+MARKS in NLS of DataStage..but could not load it correctly. For chinese characters, DataStage is reading more characters than actual. Ca...

The NLS character set in Sequential file and Table are set to UTF8

It is Oracle database.
And NLS_CHARACTER SET is "AL32UTF8"


Thanks
Sai

Can I use the existing job control routine that was generated by datastage itself?...means the "master sequencer" that i built...can i use this and change its job control routine for warnings?

Hi I have a master sequencer which calls five jobs in a sequential order. While running the master sequencer, i have given 50 warnings limit...which defaultly applies to all of the five called jobs. But, I would like to override this 50 warning limit with a 100 warning limit for only one job out of ...

Can any one please help us the problem behind nls mapping problem...

Hi I have a question on the communication b/w ETL server and DB server for a particular scenario. Assume that ETL server (DataStage) sits in machine A and DB server (Oracle) sits in Machine B. I have a job with the following format DBstage->Tfm->DBstage DB stage will connect to oracle. This job is a...