DSXchange

Sainath, I intentionally broke up the command into it's separate components so that Kumar could see what and how ICONV/OCONV work. With that information he can write the command to his wishes. I prefer this over giving the actual answer to the question - thus the longer and more complex method than ...

Phil, first off, try to do a reset of the job and look at the job log reset message, oftentimes you can get the error shown there. The "address 170" fooled you - it doesn't mean line 170, but is actually a hex offset address into the compiled pseudocode. If you _really_ like doing assembler-like deb...

Hello Kumar, the functions ICONV and OCONV will do this for you. I will split the actions into several lines, but it can be done in one line. You are not looking for a "Julian Date" but a specific date format - be careful of using misleading terms. 1. ICONV({Date},'D4/YMD[4,2,2]') Convert your displ...

Martin, the only positive spin on this port, from DS Mainframe to DS PX, would be if you are a contractor being paid for time & effort As Ray has already pointed out, just about your only common areas between the two implementations that you can (almost) automatically port are in the data's meta...

And I am leaving Europe for Australia in 1 1/2 weeks But I do think that the Australian sites re-post the same jobs almost daily; there is a very high level of duplication there. Nonetheless it seems that DataStage and DownUnder are going well together now. Hopefully we can meet sometime while we ar...

Kollurianu, if you don't tell the sequential file stage about any terminators then it will be off by one byte... the fixed-width format allows no leeway on errors What Naveen says is also true, this option should only be used if you have a file where the trailing spaces have been chopped off (some F...

Kollurianu,

the message says everything you need to know. DataStage is reading merrily along the parts of a fixed-width record. It reaches the actual file end-of-record before it's fixed-width column declaration

Amos, yes & yes. If you have frequent cases where jobs are locked even though they shouldn't be then you might bring the time down to 10 minutes (600). I don't know why the installation default is to have this turned off, it is useful and saves people (inadvertantly) doing "kill -9"s in the hope...

You can't (or shouldn't) start this daemon; if you run it as supervisor you will just sit there for 15 minutes until it wakes up. Edit the file dsdlockd.config and turn it on (start=1) and it will automatically get started the next time you start DataStage. The config file also lets you change the d...

First of all, it is best to use the dsdlockd to clear up locks. When started, it defaults to checking for deadlocks every 15 minutes; this is better than trying to do it manually.

Manually go to the Director, and use the "Cleanup Resources" tab to find the locks and process and clean them up.

Solaik, many people, including myself, have had this error. You need to look up "rollback segment error" on Google or Yahoo (google gave me over 44,000 pages). Basically, when you are writing to the database the data that is part of a transaction is stored in the rollback segments and not actually w...

Venkat, files in the repository should be deleted from the TCL level using the command "DELETE.FILE {MyFileName}", this will remove the VOC pointer to that file as well as the physical files themselves - both the D_{MyFileName} and the {MyFileName} elements. Files in other locations that are created...

Well, I've narrowed down part of the problem: If you do a: JobHandle1 = DSAttachJob('MyJob',DSJ.ERRFATAL) JobHandle2 = DSAttachJob('MyJob',DSJ.ERRFATAL) Dummy = DSDetachJob(JobHandle1) CALL DSLogInfo(DSGetJobInfo(JobHandle2,'') it will fail. This means that when y...

"Clean up"? Is that a reset or a delete or something else that you wish to do?

Venkat, if you are importing jobs and you get that warning message it means that someone is editing or using it - you can't override that, nor do you want to. You need to make sure nobody is using the jobs prior to replacing them. The mechanism that DataStage uses for functions/subroutines is differ...