DSXchange

ray.wurlod

1. Remove the first line from the file before you process it. How you do this would depend both on the toolkit available and your skill set with those tools. 2. Ignore the first line (@INROWNUM > 1 in Transformer stage). In this case you will need to set the "missing columns" rules for the Sequentia...

ray.wurlod

This is a new question. Please start a new thread with a pertinent topic.

ray.wurlod

The Filter command IS in parallel Sequential File stage.

You will find it in the Properties, in the Options folder.

ray.wurlod

Please try to maintain a professional standard of written English at DSXchange. It helps those whose first language is not English. In particular avoid SMS-style abbreviations (DSXchange is not a portable telephony device, but a forum where professionals exchange ideas).

ray.wurlod

It's not necessary to have multiple threads open for the same question. Please delete your other post. The easy choice is to add a date to the front of your time, then convert the whole to a timestamp. StringToTimestamp(DateToString(CurrentDate, "%yyyy-%mm-%dd") : " "...

ray.wurlod

Either is good. But if you're thinking about sequential mode, why not just run a server job? The overheads are far less.

ray.wurlod

You can run it from the Administrator client's Command window.

If you're logged in to the server you need to be using dssh in a project directory.

ray.wurlod

On point 2, if you send the same key at the same time from two nodes (which indicates that your partitioning needs some work) then you can introduce a deadlock situation.

ray.wurlod

Can't you just wrap this in a TO_DATE function in the INSERT statement?

ray.wurlod

Depends, I guess, on how they were changed to read-only in the first place.

ray.wurlod

DSGetJobInfo() and its ilk are not commands - they are DataStage BASIC subroutines. They are not directly invokable from the operating system. The dsjob command provides some, but not all, of the functionality. There is a C-callable DataStage API that you can use (in your own C code). You can also d...

ray.wurlod

Code: Select all

UPDATE DS_JOBS SET READONLY = 'NRO' WHERE NAME = '<<JobName>>';

ray.wurlod

Of course not, because 500 > 256, which is the value for which DataStage is checking.

If you believe this issue to be resolved, can you please mark the thread thus, by clicking on the green button at top?

ray.wurlod

The same kind of sort is performed no matter how you specify it, though the Sort stage gives more control (for example over memory used) and more options (such as the ability to generate a key change column).

You can certainly use separate stages for sorting and for removing duplicates.

ray.wurlod

Forty two.

When's the interview?

Search found 53125 matches