DSXchange

Hi, I have a job that reads an Oracle table and inserts it into a sequential file. I see an option in Sequential file stage in Input\Format tab - 'First line is column names'. I read the help on this and it says: "Select this check box if the first row of data in the file contains column names....

Every time you run the job does it clear the hash file before writing the new records into it. If yes then where are you performing the clear of file.

Regards,
-Sumit

Are you giving an invocation id different from all the other invocation ids running. Regards, -Sumit I've got a multiple instance job but when I call it with more than 3 or 4 instances I get the error "(DSOpenJob) Cannot get shared access to executable file for job ". The job is an unload ...

I did not quite understand your question but here is what I have to say. If you have a look up to the hash file in you job then you need to execute the hash job atleast once in order to create the hash file. The correct way to deal with it is to remove the look up if you are not using the underlying...

Thanks for the suggestion guys. I will have to go through the jobs again to see if this can be achieved using a file instead of a temporary table.

Thanks again,
-Sumit

The immediate fix to the issue would be to use the sum of the last Key value and the sequence number. For example say the last value of the key was 9999999999 before the rollback to 1 happen. Then your expression should be KeyMgtGetNextValueConcurrent('<Your sequence Name>')+9999999999. Regards, Sumit

Hi All, I have two jobs 1) Job A creates a table X first and then populates data into it. 2) Job B processes data from table X into another table and then drops table X. There is a sequencer calling Job A and then Job B. The problem is if Job B fails for some reason I have to manually drop table X b...

Thanks guys for the suggestions. The macro DSJobInvocationId solved all the issues.

Thanks again
-Sumit

When I schedule the main sequencer job I type the invocation id. Now when this main sequencer calls the other jobs I need following two things: 1) It should pass the sequencer invocation id to the invocation id of the called jobs. I can achieve this by using the following code in the Invocation Id e...

Hi All, I have a multiple instance sequencer Job that calls various other multiple instance jobs. Whenever I run a serquencer job I give an Invocation id. Now is there any was to capture this invocation id within the sequencer job and pass it to the other multiple instance jobs that the sequencer is...

Thanks Craig, right now I am using DataStage sequence as a work around. I guess I will have to convince the DBA to allow us to create a sequence.

I still would like to know if there is any way to issue a table lock from a DataStage job.

Thanks and Regards,
-Sumit

Hi All, I have an Oracle table A that has only one row. I have the following requirement: 1) Read table A and get the value of J_ID from it. 2) Increment the value by 1 and update it back to J_ID in table A. Now, I want the moment I read the J_ID value from the table the row should get locked and no...

The import process will automatically upgrade your jobs to the current version. What version are you importing from? Thats what my question is. Does a dsx file store any information about the version of the tool using which the dsx file was created? Other things off the top of my head - are you run...

Two ways of doing it: 1) Create a job that takes that inserts data in SDKSequences file. You know it has one key column and the other column that stores the last sequence value. 2) Create a routine. Call the key management routine using a FOR loop as many times as the maximum value you would want to...

Use Substrings function. All you want is the first two numbers from the date. Substrings(<your date column name>,1,2) Say your column name is CurrentDate then the function becomes: Substrings(CurrnetDate, 1, 2) Regards, -Sumit Hello there, I am trying to separate date from a date record in 'ddyyyy' ...