DSXchange

Hi all,

if i hope to use BCI to connect to my database, all i need is to buy the DataDirect Driver through Ascential..or DataDirect??
Also could i connect through BCI if i use other licensed ODBC driver on AIX?
Thanks

Cal

Thank you very much. That is what i want. And I am trying these functions now!

Cal

um..what i actually want to do is to group several parameters into one parameter and pass to another job as a String, then to write some method that can easily create this "string" and get value from this "string". is it possible?

Cal

Hi all, I would like to know is there object oriented concept in DataStage? Since now i have a generic job sequence model, every job will pass necessary parameters to this model to trigger corresponding jobs. However i find that there are too many parameters and every job may have different numbers ...

Thank you! I did find out the way now! Data Direct Connect ODBC is bundle with DataStage. And so there is free odbc drivers for different database connections. But the license states that we can only use Datastage for this driver. And I could create routine to fetch sequence number using BCI functio...

Thank you. But this indirect way need a text file as a bridge, and if many jobs run at the same time, it will have syncronization problem. (many jobs update the text file at the same time). Some jobs might get the same id or the sequence will get "jump". That is why i hope to have a method...

Thanks many all your help. to make it clear, i explain in more detail on what i need...I need a JOBID for logging each job runs. And the jobid, as suggested by my supervisor, should be retreived from a DB2 Sequence. And so, every jobs start i need to retreive the sequence number. I am wondering how ...

Since i have hundreds of jobs running at the same time, retreiving the sequence number, if i put it in hash file...will it cause sync problem?? or the file is locked?? or always need to wait?
and so i just hope a direct db connection will be better. correct me if i am wrong.
Thanks.

Cal

BCI only supports ODBC?? does it contain the driver for db2? oracle?

But if i use user-defined SQL for the sequence number, how can i get the data back to my DS script? populate to text file then read?
Thank you.

Cal

Dear all,

what method/routine can i use to read config from database tables in DataStage??? also...I hope to use my own sequence in database to keep track w my job logs instead of the DS one. How can i read the sequence number and parse to the Job control?
Thank you very much!

Cal

Thank you!
I use openSeq to test if the file exists, is it a solution too?

Thank you for your help!
by the way, if there are hundreds of jobs running on server, will it affect the performance?? Since most jobs are LOOPING ...SLEEPING...CHECKING FLAG...all the time.

Cal

Dear all, I encounter another problem. If one sets the time limit to say every 300 minutes to run the job and in my script there is a statement like SLEEP 300mins * 60 - job run time, and then someone hopes to stop and reschedule to run the job every 10 minutes immediately, how do i cope with this s...

Thanks so much!!
You've solved my problem. The time limit should be set as job paremeter. If one hopes to change the schedule must stop the job and start again to enter the new paremeter. Maybe I thought too much and actually it is straight forward. Anyway, thank you.

Cal

Thank you very much! and it means that i can make some control jobs to create those flag files automatically so that i can easily stop/pause the job by the director, rite? how about the time limit, how u do that? create a config file and the job read parameter from the file? one problem is that if a...