DSXchange

Are you using the Sequential File stage? Please post the error message.

John

It appears that you have a fixed width file with no line termination. Is that what you have set in the stage? In your example, are you using a period "." to designate a space? RAY.......FITZGERALD.HIGGINS...MICHAEL....ORLOW.....JANICE....H If that is true then your schema is correct if you...

Did you telnet using the server name or an IP? Due to network/domain issues I have to use the IP when I login to DataStage from my workstation.

You might try typing in the IP as the Host Name.

John

I don't know what was fixed in 7.5, but I'm on 7.5.2 and View Data using $PROJDEF still does not get the value from the project.

John

I just want to clarify one thing - View Data does not use user defined environment variables well. You have to type in the values when it prompts, you can't just use $PROJ_DEF. Later in the posting you said you ran the job - that will use the environment variable's value. Just making sure we are com...

I was a bit off-topic at that point in the thread. You're clearly closer to the problem.

John

The original post is loading into a table so that is where the keys are relevant. Loading into a text file is a test to see where the slowdown is.

John

Do you know if these records are unique based on the primary key before you try to load them? If you do, you can disable the primary key index before you load them and then enable it again when you are done. Same thing with foreign keys - if you know they are valid then you can disable the FK constr...

For numbers I would remove the plus "+" sign and any spaces. I've never tried loading a trailing negative sign so you might have to detect it, remove it then use the NEG() function (or move it to the front of the number). Since you start with a string, there is always the possibility of no...

If the code you posted is in the JobControl job then DSJ.ME refers to the JobControl job, not the job you want to run "manishtest" Job_Name1 = DSAttachJob(DSJ.ME,DSJ.ERRFATAL) Dummy = DSSetParam(Job_Name1, "FileWatch",DSJ.PARAMDEFAULT) Dummy1 = DSSetParam(Job_Name1, "Loop&qu...

Please clarify if Arg1 is an input, input/output or output parameter. Way back on v6.01 the code generated by an import function incorrectly identifed the parameters. I doubt it has changed. If Arg1 is an output parameter, change to ARGTYPES = DSOLE.ATYPE.REFSTRING I'm not sure what to set it to if ...

CR/LF is the abbreviation for Carriage Return/Linefeed, the common Windows line termination. If the file has too many CR/LF's at the bottom of the file it will return this error. The typical Windows text editors (NotePad and WordPad) won't show these characters visually, but you can tell they are th...

There are a couple of ways to "stop" a job in Director. You should tell us what you've tried. Here are the options: 1. highlight the job and hit the 'stop' button 2. go to Job|Cleanup Resources (if enabled on this project) You'll have to find the process (PID) of the job. Then log it out/c...

I would look at the file in a real text editor to see where the carriage return/linefeeds are. I suspect you have a couple of extra CR/LF's at the end of the file.

John

You might have to explain this further - I understand this is a PX topic. This is what I am doing in a derivation: IF ValidDateOpen = '0' THEN SetNull() ELSE ValidDateOpen[1,4] : '-' : ValidDateOpen[5,2] : '-' : ValidDateOpen[7,2] : ' 00:00:00' ValidDateOpen is a VarChar stage variable that verifies...