DSXchange

Thanks ray. This discussion has been a great learning for me. It has inspired me to learnuniverse. what should be the best source to learn universe?



Thanks

Dhiraj

P.S. well and on pandora's box , i think i'm not matured enough in datastage to comment on it.

what is an dictionary item?

"You want this then you need to create dictionary items for DEPEND_TYPE and DEPEND_JOB."

how do we create it ?

thanks,

dhiraj

Paul,

Is inter process row buffering turned on your job.?
if so try running the job after disabling it.

i have jobs which extracts over 12 million records from a table ( approx 6 gb of data in flat file). so i guess data stage resources shouldn't be the problem.

dhiraj

How are you generating that control report?

are you using a basic routine for that? if so i guess u can use dsgetloginfo() to get the number of records written to each link(odbc). Look in to the documentation for more info.

Dhiraj

Clean up resource is not enabled in your director because you've not enabled run time job administration in your project. to do this log on to administrator , select the project , go to properties, select the check box stating "enable run time job aministration in director". Click ok. clos...

Thanks Ray. Thanks Kim. 1) Can u please explain the query which retrieves the names of all linked jobs to a given sequence job, given below SELECT EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',32,'X')" AS DEPEND_TYPE FMT '3R', EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',...

thanks kim! is there any way we can do this in the script ? can i execute this SQL from a script, will i require any driver for it? or is there any other way of achieving my goal from script? the reason why i want to this from a script is that , my company want's to restrict the use of basic routine...

Here it is. I've given the script which retrieves the log.Can any one please help? Paul, I am not sure of the universe tables and the relationship between them. can u explain how we can retrieve that information using basic.i mean the details about the sequence job and all the server jobs related to...

Hi, We run data stage server jobs using perl script. We have written a generic perl script which takes the job name and parameters as argument and executes the datastage job using the dsjob command.It also captures the log of the job and writes in a seperate file. Now the problem is that when i run ...

Preethi, Do you mean you want to connect to a remote datastage server/file server using VPN? IF so then you have to first eshtablish a VPN tunnel from your machine or Network to the remote server. This has to be done in the firewall and not in datastage. Once the VPN tunnel is up you can access the ...

oops i forgot to tell this. When i import the table definition of a SQL server 2000 table Using an OLEDB plug in stage the metadata for date time field appears to be as time stamp of length 30 with scale as 0. But when i do the same thing using an ODBC stage i get it as Timestamp of 23 with a scale ...

Hi, I have a datastage job which reads from a seq file ,looks up in to an OLEDB stage (based on a character field and a date time field) and writes the looked up value to an output seq file. THe OLEDB has been set up for an SQL server 2000. When ever i run the job i get the following error message. ...

datastage stores all the columns of a record in a sequence. and since your record seems to be very small it should make no difference to performance. whether you retrieve the selective columns or all the columns of the record, datastage has to apply the same hashing algorithm to your keys.

Hi, I am using an UV stage to access a hashed file.Hash file is defined with three keys A,B and C. In which A is of type char and B & C are timestamps.My look up condition to the hashed file(using UV stage) has an equal to (=) contion on column A ,Less Than ( <) condition on column B and greater...

Hi,

Can i write to same hashed file from more then one stage in a job.I want to recreate the file for each run.

I tried doing this and this worked.

But i wanted to know if it is safe doing this.

thanks
dhiraj