DSXchange

while I couldn't get the override file to work, I did manage to solve the problem that I wanted to use the custom sort sequence for in the first place. It was sorting an unprintable character (ebcdic 3f) below spaces (40 in ebcdic) - as it should. DS represented that empty char as '?'. So I'm not ma...

When i checked with the developer he has said that there is no such primary key violation (he is not inserting any duplicate records) and same job runs fine say for the first time. So in the first run, you are inserting some records... if i run the same job again it is throwing an error Network buf...

So I have a problem with a ? mark not being sorted in the way I would like. I would like to fix this by using a custom collating file. So I make a test job. row gen - > sort stage, descending by sort_key -> dataset sort_key values: A, ?, ' ',4, 2 I set every stage to sequential I edit a file /direct...

ray.wurlod wrote:Quick! How long is a piece of string? I need to know urgently!

Also what is the sound of one hand clapping?

*crickets*

I understand what you are saying, but this is not a warning limit I appear to be running up against. This appears to be related to the errors from SQL Loader. The logs I included were from the SQL Loader log in the Information Server's Scratch directory. Thanks! Looks like you answered your own que...

Thank you!

For those that were wondering, my post of original post of thanks was validated - I am now certified.

Hello,

I don't see an introduction forum, so I thought I'd make myself known here. I'm fairly new to datastage - going to get certified in DS px 7.5 tomorrow. This site has been a great resource helping me prepare for my test.

I hope... I guess I'll find out tomorrow.

Vishal, you need to read a little more carefully... ... to read the dataset, all the nodes using which the dataset was created must be present in the configuration file... Ok, so the grammar is a little off, but basically I parsed this as: To read the dataset, all of the nodes which were used to cre...