DSXchange

Dear all,
I was compiling a job and during this operation i had a fault. If I try to reopen this job in the designer I have the following
message:
Job Step1 is being accessed by another user

How can I unlock it?

Thanks,
Ugo Mascetti

This is a topic for an orphaned message.

Hi to all, Id like to know, why after only 1 warnings my job go to abort also if ive set the option of limit warnings to abort = 50. Ive datastage 4.1 on hp-ux 11.0 Please share your ideas on this. Thanks and Regards Micarelli Cristiano The Technology Partners Via Nepal 29 - 00144 Roma office: +39 0...

Dear all,
I have a job sequence with three jobs that can run together.
I havent installed the axcel pack.
How can I run these jobs simultan. on three different processors? It is possible without the axcel pack?? Thanks in advance, Ugo Mascetti

Sure, thats fairly easily done. You just need to read the flat file using DataStage basic in the batch job and then use the DSSetParam function to set each parameter to the appropriate value before launching the job. Check out the various Sequential file handling statements in your Server Job Develo...

Hi all, As we are new to this forum, theres one question and your timely would be really helpful to us. We have to take the value from a text file (basically filepath) and set it as a parameter to the main batch. What is the way to do it and how do u do it ? Is there any code ? Thanks all, "Analysts...

You probably received an error when you opened this before. If you can see the tables and links on another PC, you will need to reinstall the bad PC. This is a known bug. You will need to uninstall DataStage and remove all links in the registry. Then, reinstall DataStage. You may want to talk with s...

Hi all, I am trying to import a MS Sql server stored procedure using manager. Clinking on details I get Owner: dbo Qualifier: ods Fully Qualified Name: "ods"."dbo"."usp_Bills_ValidateIndividual;1" Unqualified Name: usp_Bills_ValidateIndividual;1 Parameters: @ConsumerNo (IP), @BillNo (IP) Result Colu...

How about: DSGetJobInfo(DSJ.ME, DS.JOBNAME) : " " : DSGetJobInfo(DSJ.ME, DS.JOBSTARTTIME) Kasia Lewicka cc: Subject: job id 01/06/2002 00:41 Please respond to datastage-users How to get an unique id for a job run? (for information : I would like to get this id when I run the job, and put it then in ...

Used this for years. Setup a DataStage batch job with two parameters: SearchText and Folder. SearchText is for substring selection of jobs logs for clearning. Folder is for limiting the SearchText to looking in a specific Folder. No SearchText means all jobs if you didnt limit by folder. Paste the f...

Hi All!

Is there a tool or a way to clear the logs of multiple jobs in Director in one single operation?

Thanks

Have a nice weekend!

Christin

Your solution is not suitable for us (we need a real increment count). Pity that it couldnt be done with a DSMacro or Constant. I will try the routine proposed by Phaneender Aedla. Thanks for suggestions Kasia At 15:00 31/05/2002, you wrote: >Hi Kasia, > >If you just want an incrementing count for a...

How to get an unique id for a job run?

(for information : I would like to get this id when I run the job, and put
it then in my log file, after the job finish)



Kasia

Hi Kasia, If you just want an incrementing count for a run of a particular job, and you dont mind your count being reset when you recompile the job, you can use the internal wave number as a job run sequence number. One way to do this would be to write a routine in the Manager as follows: $INCLUDE D...

Hi, You could probably use KeyMgtGetNextValue or KeyMgtGetNextValueConcurrent under Routines --> sdk --> KeyMgt, in the Manager. regards, A -----Original Message----- From: Kasia Lewicka [mailto:katarzyna.lewicka@cgey.com] Sent: Friday, May 31, 2002 8:11 PM To: datastage-users@oliver.com Subject: jo...