DSXchange

That is correct. As mentioned by Craig. As there is nothing more to delete, it provides that warning. What is your commit level set. I mean what is the transaction size ?

Conversions in PX require explicit handling. You are getting warning because the engine is doing it implicitly and thus screaming, and yes the warning messages are per row basis. I advise use Modify stage to handle exlicit datatype conversions.

i believe svCREATIONDATE is a stage variable. Its simply checking if its the first row then current timestamp, else use the derivation in svCREATIONDATE. Now you need to see whats in svCREATIONDATE.

Is your hashed file present in the Project directory or somwhere else. As pointed out, you need to create a VOC pointer for your 'out for directory' hashed files and then use that pointer as your hashed file name. You need SETFILE for that. If you dont want that then change the UtilityHashLookup rou...

You need to provide a value for that question mark, as in, a value for the batch id. If no value is provided you will have incomplete where predicate and hence an incomplete sql command.

Use the advice given earlier to extend to your current requirement. Have your control job run every day. Check if todays date is 4th business day or not. You can use ICONV/OCONV with DW for that. If yes, then run batch1 else run batch2.

I believe you have special characters in your parameters or maybe even password. Do an exact search on "Incorrect dboption list" and you will find that this has been discussed here before.

I believe you will have to spot check. i bet your database is Oracle. Right... ? This has been discussed here before and i believe that spot check is the only way to tell.

In JobControl. You can also do this in an after job subroutine where you can use Basic.

Good piece of advice by Craig. If you want to make this dynamice then as Craig said, have a job that checks the date from oracle table. A job that is scheduled to run everyday that checks the current date with the dates in the oracle table, if there is a hit, it puts out a flag in a file. The batch ...

More like Sixer E3. Great work ArndW. Got to learn a lot from you. A true asset to DSXchange. Keep it up in helping us understand this tool and technology even more.

You can also look into the FIX() function.

I doubt you can do a bulk dump to a text file.(Someone correct me if i am wrong) You can surely read it row by row depending upon what key you pass in. You will also be needing to know all the keys for all the hashed files. I think you will be better off creating jobs. You can also pass a select com...

Welcome Aboard
You need to sort the incoming data with the first column and then the second column. You need to do a row by row comparison. Hereis a similar example.

Not possible. Just split the job into two jobs. First job does the link collector part and the second one does the bottom part.