DSXchange

Welcome! :D Always best to start your own thread and then reference / link to any older thread that inspired you. That way we have a clue what your 'particulars' are - O/S, DS version, etc. So I'd propose you do that - start a new thread in the proper forum based on your job type, Server or PX, as t...

I added a hash file between the oracle lookup stage and the transformer. Always best to give as much information as possible from the beginning. You hadn't mentioned any Oracle lookup that I recall. So, you replaced an OCI lookup with a Hashed File lookup? Hashed files are the heart and soul of the...

If you are on a 7.5.x version and thus have the new Start Loop, End Loop and UserVariables stages you can build a looping Sequence job. You would first get a list of your parameters from the file using the UserVariables stage and then it would pass them, one at a time, to your Loop that runs the pro...

Wolfgang, I think you've missed something. This is perfectly valid 'job control' code and seems to have been cloned from the 'Add Job' function. Ok, in pondering this - we've both made assumptions. I assumed a separate 'job control' job being run that in turn runs the other job. Luc, is that the ca...

Wolfgang, I think you've missed something. This is perfectly valid 'job control' code and seems to have been cloned from the 'Add Job' function. One problem, Luc, is the fact that you don't check the success or failure of your operations before the job is run. You should check to see if the DSSetPar...

Does 'without delimiter' means a fixed-width file? If so, it's just a matter of a check box and getting the Display sizes correct.

You won't be able to 'omit' the first two records, but you could easily constrain your job to only handle from record 3 onward. For example...

satyanarayana wrote:you can use DSJobStartTimestamp OR DSJobStartDate

Correct, those are macros that would give you a static value, if that's what one needed.

How shall i get the system date in datastage .. . Is it an function or a datastage defined constant Yes. You've got both. Check the online help for: Date() @DATE Time() @TIME TimeDate() These are various ways to get the time and/or date from the system. What Vijaydev mention...

I'd wager it's all about the timing. Too much going on when the jobs were first run, but after taking the time to compile them after the failure, they run fine because other processes have completed and they were able to start within the timeout period. :D I really doubt the recompile 'fixed' anythi...

The data is coming to you 'encrypted' or do you need to perform the encryption during the load? If you don't need to do the encryption or any kind of decryption during the processing, I don't see why it couldn't be treated like any other 'data' - simply stored and retrieved from the database. Would ...

You don't necessarily need any kind of hashing algorithm. We do something like this with a database table and a generated surrogate key. The 'string' value is the PK and DS jobs maintain the information in the database. New string values get assigned new surrogate ids and lookups get you the surroga...

DSguru2B wrote:Doing it in the Administrator will set all sequence jobs as 'restartable'.

No, it won't. That just sets the default check-boxes for any new jobs created after the change.

And? Do you have a question? Guess we get to infer one...

Use -warn 0 at the command line to override the Project default of 50. Or handle the problems generating the warnings in your job.

Ok (Conditional) = file found, Otherwise = file not found. Use a Sequencer so Job2 doesn't need to be included twice. Or just include it twice.

When inserting en updating more and more data to a oracle table the performance slowly decreases from 86 rows to eventually a 3/1 rows per second. If "inserting and updating" means you are using one of the 'combo' Update actions, then that is probably the heart of your problem. Never mind the fact ...