DSXchange

both sh and ksh should work; and I just saw that the message you posted did specify "sh". Does your search path include the "." directory?

Mahesh,

the BASIC manual on page 8-658 tells that the status value of -4 after a WRITESEQ is caused by "The write operation failed because the device ran out of disk space."

Are you using the correct shell?

Craig,

I hadn't thought about that ADMIN thing - but I did just test it and it works, the COMO file does stay on until the session is ended or it is turned off, all terminal I/O gets echoed into the file.

I've filled up a disk or two by forgetting to turn off my COMO files!

bala_135, open up the installation guide (you can also find it in your client docs directory as the file "instconf.pdf") and follow the configuration instructions for ORACLE to the letter. Once you have done that and confirmed that you haven't missed out any steps and it still doesn't work then some...

Yes, you need to revisit your installation steps per the guide.

Palaniappan,

the best description is in the documentation for NLS, but in a nutshell is tells DS whic language and locale to use.

If you did a date day conversion with the NLS_LANG set to German it would return "Donnerstag" for today, normally you would see "Thursday".

Did you follow the specific configuration steps outlined for Oracle in the installation guide? It looks like you might have missed these. If you can connect to Oracle from the DataStage server machine using sqlplus or whatever access tool you normally use then it is a DS configuration issue - otherw...

This looks very much like a configuration issue. Is this the only job with a problem and has Oracle been accessed from PX in this installation already? PX requires a number of steps to be taken and grants to be made in order to function correctly. If this issue isn't limited to your one job, then yo...

If you are in TCL then you can enter "COMO ON {ChooseAFileName}", then your LIST DS_JOB and finally a "COMO OFF". It will echo all of the screen IO into a file called {ChooseAFileName} in a subdirectory called &COMO& underneath the project.

Hello Sachinamr,

this subject has been talked about in many threads. You can use a UNIX or Windows CMD program called dsjob to do this. If you call it without parameters it will show you the help options, but it is best to read about it in the documentation.

I've found that different places in PX require different formats for just about everything. If this isn't a huge volume job, use CHAR(000) and CHAR(001) instead of the direct literal so that you can continue developing while perhaps waiting for the correct answer.

The value for number of warnings you specify in the scheduler overrides the default value set in the job; so if you wish the job to abort after a given number of warnings you need to change the value of 0 you have set in the schedule.

Mayer,

what is your pure read speed for the main data? What is your pure read speed for one of your lookup tables into a hashed file? Surely more than 1 row per second?

I misunderstood your original post, I thought you wanted to do a comparison of fields in one row, but you wish to do this across more than one row. In this case the approach is different. If you only have 2 rows across which you want to find the highest, then you can use stage variables to store the...