DSXchange

Exactly - you control when the values changes and it doesn't matter what it is. We typically used a Mod() function to increment a counter every X output records.

It is getting created, just not where you are expecting. Relative pathed files end up in the job's Project directory, check there.

I was able to configure the pivot stage but the output is not correct, it splits the records into 4 columns and 4 rows. Then you didn't configure it quite correctly. The first column should be marked as a key and you'll need to create a fake key column for that with a constant value so the data val...

Did you try right-clicking in the monitor pane?

That would be a "vertical pivot", you can search the forums for the tecniques involved. Only thing "extra" you'd need to do is take the separate columns the pivout would generate and concatenate them into a single column post-pivot.

Welcome. What exactly do you mean by 'unable to view it on the schedule'? Meaning you don't see it in the DataStage Director client or it's not in the crontab entry for the scheduling user? The former shouldn't really be happening but the latter would be a case of looking in the wrong place. Recurri...

It is specified in the error message - SQL Server.

Yes - *if* that is the problem. However, doesn't sound like it is. What is your script actually doing? What kind of status does it return?

Do you have the 'automatically handle' option turned on? It considers any 'non-zero' return code to be a failure. What happens if you turn that off if on?

Someone must have those privledges, can you not have them take care of this for you? Also curious if you can actually check the privledges on those objects rather than assume everything is ok.

Specifically, sounds like "type 2" SCD processing.

Have you tried the suggested force compile?

Query isn't the issue and as noted it is a database deadlock. You could be locking yourself or you could have had the bad luck to be deadlocked against another process. Is this repeatable? Does running on one node solve the problem? If yes, you may be able to solve this by using intelligent hash par...

That's good to know. I always thought it was odd the games you had to play for simple inserts and haven't had a chance yet to work on a system with connector stages yet.

No worries, just meant that most operating systems (in my admittedly somwhat limited experience) include 'large file support' out of the box in this day and age of gigabyte flashdrives rather than 1.44MB floppies.