DSXchange

That is an error message I haven't seen in DataStage before. First question would be - are you doing any square root computations in your job at all? Could you post the full error text as well as your exact version of DataStage? It might be possible to trace this to the line of code if it is happeni...

I really am curious. If you measure your current dsrpcd size, then bounce the DS engine, what size is the newly started dsrpcd? This will help determine if some setting(s) have increased the base size or if, for some reason, you have a memory growth issue.

The scaling of the new AIX machines is a complex matter and the information given so far isn't quite enough to come close. The actual load that production is going to have plays a very big role and you haven't touched upon that issue yet. If you go for the P-Series architecture you can scale the num...

Does the dsrpcd take up the same amount after you bring down and restart DataStage as well?

Have you made any changes to your uvconfig file?

The separators most commonly used are @FM, @VM, @SM and @TM (Field, Value, Sub-Value and Text marks). The BASIC Programmer's Guide give a good description of these characters in one of the beginning chapters that is worth reading.

I suggested you have DS create a SQL query so that you can look at how it handles placeholders and not to really execute your logic.

OK, that is what I thought but couldn't remember. This is similar to the REMOVE statement and it works on "dynamic arrays" or strings that have the special DS delimiters and therefore is not the function that you are looking for. If your goal is to strip out all occurrences of a given single charact...

MacLeo,

the first line in the log file when you run a job contains the full ENV settings. Could you check there to make sure the correct path is set? If not, you would need to correct that in the dsenv file.

I can't remember the exact syntax of the REMOVE function (there is a REMOVE statement as well, but that does something quite different). I don't have DS on this machine, but if you open up your PDF BASIC Programmer's Guide you can find the definition and description of the function.

Hello Ambasta and welcome to DSXChange. If you post your problem in the correct forum you will get a better and more accurate set of responses. In this case you posted in "General" but there are differences in what might be happening depending upon whether you are using PX or Server. Also, as an eti...

The DataStage PX product does not have the capability out of the box of directly reading UniVerse or DataStage Hashed Files. This is why Ray politely suggested using Server. If you need to process Hashed files you will need to use ODBC in PX jobs or write your own stage. I suggest you see if you can...

I did a google search for OpenOffice and ODBC. I made the mistake of assuming you were going to UNIX, but if you remain on Windows for both OpenOffice and DataStage you should be all set. I do agree with Kim and recommend using .csv files as a transfer medium to avoid problems in the future.

Open Office has ODBC drivers available, so you should be able to connect and read the spreadsheet data in much the same way you have alread done. But ODBC connectivity on Windows is builtin to the OS; whereas on UNIX it might not be as easy to ensure that the drivers will connect to DataStage. DataS...

You are using the aggregator stage to perform some sort of group level operations. Unless you sort the data coming in and tell the stage that the data is sorted it will need to use both memory and DS Server disk space to temporarily store data. If you can select your data in sorted order and set the...

The error message you are showing is that the transform stage object code generated when you compile your job is not found and it doesn't list your user-defined object. Could it be that your routine changes the CWD and it was called successfully but has changed the attach point and thus the DS trans...