DSXchange

Craig - hmm, I could have sworn I read that the original requestor just wanted a count. Oh well, it would be a bit of BASIC code or perl to locate the BEGIN DSJOB line and the extract the quoted text from the following line.

I usually prefer to create a new 64BIT file with a minimum.modulo and then copy the original data over. This leaves me more comfortable with going away and having lots of coffee or a dinner and a movie while the file is being loaded. The issue with the RESIZE is that the file gets locked and if some...

You probably have it but can't find it. Sometimes "find" doesn't locate files the way it should. I can't remember where those files are created, but would think somewhere in the Oracle directory tree. You will need to search around a bit - perhaps look for "ora*.log" to locate the correct directory.

...But when i run them from sequencer, the datasets are not updated with correct/latest information... What is your timing in the sequencer, you should have the completion of the first job trigger the next; it seem that you are not doing this and thus might be getting a copy of the old datasets bef...

Just so I understand what you tried, you have a .dsx export file and now you call up the import datastage components tab in the manager, and select the "import selected" tab. You then get a screen where you can select the job(s) to import and after you select the one job to restore you then get an e...

Often a 1-node configuration will run better than a 2 or 4 node configuration. It is hard to know which level of parallelism will result in best performance in a production environment. My approach is: a) Always design with a 2 (or more) node configuration. This ensures that your lookup and other pa...

You can get the job number by issuing the TCL or Admin command "SELECT JOBNO FROM DS_JOBS WHERE NAME EQ '{jobname}'", then go into the subdirectory RT_SC{jobno} and look at the UNIX date/time created stamps on the files in there. Offhand I can't recall the names, but I think the file OshScript.osh w...

using the format OCONV(ICONV(DSLink9.Field003,"D2-DMY[2,2,2]"),"D2-YMD[4,2,2]"):" 00:00:00.000" on "31/09/07" cannot result in an output of "Ist October 2007". Go into the Manager and create a new server routine. Put in one line into the program Ans=ICONV(Arg1,"D2-YMD[4,2,2]") and ...

Do you get the same error when typing "RESIZE MyHashFile * * *"? Can you do a "COUNT MyHashFile USING DICT VOC"?

Sure, try "String1=String2"

String comparisons are commonly used in DS, so unless you narrow down your question you won't get more than a generic answer.

I'm not at a machine with an export file, but I think should do the trick

rumu - you have an "urgent" problem yet will not think about joining DSXchange for a mere pittance? And then you request that Ray disclose premium content? That is an odd way of looking at the benefit or value of this forum.

As I mentioned before in this thread, you would need to write a routine in order to use the STATUS() value for an ICONV() or OCONV() call.
Which format did you use on "31/09/07"?

devidotcom wrote:kill -9 PID

Use the above command. But please don't kill any process as mentioned to you earlier. This was for FYI.

NEVER do a kill -9 {pid} for DataStage processes unless all other options have been tried.