DSXchange

The UNAVAILABLE usually refers to a session which DataStage thinks is still alive but whose UNIX process is no longer present. Usually this is because the process has terminated with an unhandled abort, most often when a "kill -9" is issued to it.

The PORT.STATUS command is not included the VOC files of any projects, only in the master UV account.

You probably have a PRECISION of 14 set, so using FMT and a number with more digits is not going to work correctly. Try IF DSLink3.Field001<0 THEN -':FMT(ABS(DSLink3.Field001),'11"0"R'):'.00000' ELSE FMT(DSLink3.Field001,'12"0"R'):'.00000' Note I used the ...

I do understand. Did you check to see what these processes are doing using the truss command as I suggested earlier?

Cesare - when you ran it from the before-job did it also display the contents of the directory? Or just not give an error? (I'm surprised that it worked, that's all). Also, could you try it with the command "dir G:\tt" as well?

PX has a surrogate key stage; but it generates unique keys only within the job itself. But you can specify the starting value dynamically, i.e. through a parameter to the job. If you can think of an algorithm that ensures each job only uses a given range of numbers you can use that method. The gener...

Sumesh,

You don't need to use the L and R functions, or even any string formatting options at all, you can use FMT(DSLink3.Field001,'18"0"R5')

Also note that your error is not the database access stage but in the PEEK stage.

xjonny, you have posted to many problems at once and it is hard to tell now what is cause and what is effect. You have tried to bring up DataStage while there are still processes up and running, which is why the engine has not correctly started. After bringing down the engine you need to ensure that...

No, it is normal navigational links; i.e. when I have the list of new posts and click on one to view it. Even though I've just looked at a previous one, I'll get the login screen again. If I close the window, reopen it at the top level then my login cookie is also gone and I need to re-enter the use...

I agree with Ray's suggestion. Write a SERVER job to do this. Write a routine "ConvertStringToNumAscii(InString)" with the following code: Ans = '' StringLen = LEN(InString) FOR Counter = 1 TO StringLen Ans := FMT(SEQ(InString[Counter,1],"3'0'R") NEXT Counter I added th...

To take out the hashed-file variable from this and confirming that it is a mapping/permissions issue at a userid level from Windows please try to execute a DOS command in the before-job call for this job - "dir \\YourServer\YourFolder " and see what the error message is. Are you running the job with...

I think using job name is better - since the JOBNO for a job may change (re-import to another project, saving of a copy, etc.).
Are you looking at something like an Oracle Sequence, but driven from DataStage?

String lengths of 20 and 200 are not particularly long and should cause no issues. What stage are you using for the concatenation? Have you found a length of C1 which works, and where length+1 doesn't? Is it consistent with length?

In the past 2 days I've been going through threads and at some point during the session I get the login screen when clicking on a link; it seems my session has not only been lost but when I close the explorer window and re-open it to DSXchange it has forgotten my password. This has happened to me on...