DSXchange

Thanks, Let me try and do this.

Hi, Need some advise and input. I have a report file, need to read the file and get the information from the report and load it to a database. which has header, address, date information and data information as rows. What is the best way to get the report data to table format. Any help is appreciate...

This is how you call DSGetStageInfo. This code is a part of DsWebMon. Hi Kim, could you please guide me to write the MonitorGrid to a Flat file by Stage name, LinkName and other details Thanks in advance subroutine DwnGetMonitor(JobName, MonitorGrid) * ----------------------------------------------...

I tried LIST.READU command then UNLOCK USER #### ALL command... I don't have lock management access to perform.
and looks like deadlock deamon is also not running!!!

Thank Ray!!!

Hi,
You mean to say use routine or use JobControl area to create a Basic program is it?

while i am reading thru the Basic programming document, i found this example to edit or create a Basic program, but I am little confused can any one guide me to create a basic program using Unix/ DataStage prompt. Editing Programs in DataStage On UNIX systems you can invoke vi from the DataStage sys...

You are correct ArndW I did use Kill -9. It's been one week still my routines are locked... looks like Deadlock deamon is not running.
is they any other way to release.

thanks

Hi, One of my routine is locked while i am tesing it and i went i kill the process from unix , before that i tried to logout from "Clean Up Resource" thru Director and it did not get logged out then i kill the process from Unix. But when i tried to open the routine it still says " Rou...

You are getting the system date successfully, as is obvious from your error message. What you're not doing is handling it correctly. Need more information about what you are doing to provide specific help. What target database, target field, stage used, target datatype, etc. You'll more than likely...

Thanks Arnd! I was able to get the job log details loaded onto a file with dsjob in UNIX. But can you please tell me where these hashed files exist in the server. Regards, Rony Hi Rony, Could you please share the code or syntax - how you did get the log details to flat file using dsjob in unix. Tha...

Thanks for all the information.
I will try to incorporate to use Environment Variables.

1. As long as passwords aren't setup as encrypted, but strings, a mass text replace in the dsx should do the trick. You must recompile everything. 2. Parameter default values are okay to change, but you must recompile everything for those defaults to be effective. Just fix the problem once and for ...

Hi, The question i am going to ask is all ready been discussed in this message board but i have doubt. I got a requirement that i need to change the User Id and Password for DataStage jobs and sequencers. I have lot of jobs to make the above changes. Case -1:- When i looked at the Job Sequencers the...

Hi Duke,

Can you please post the total code what you are mentioning.

Thanks