DSXchange

If I understand the problem, have you tried to use the function Ereplace(String,',',' ') ? The data 7.4 must be converted to 'blank'||7.4 or 'blank'||'blank'||7.4

The job is:
Oci Stage -> Transformer -> Oci Stage
The job perform an Update / Insert record
Hope this is useful

Hi all. I have to load a table with a file of 3.5 Gb corrisponding to 9.000.000 record. Initially DataStage loads record at 1.500 rows/second but, after 2.000.000 record, it decrease to 500 r/s ad finish at 250 r/s. Is there an answer to this behaviour ? In which way can i increase the performace ? ...

I've installed the SP2 Patch but it doesn't resolve the problem; with other patch are you talking about ? Where I can find it ? Thanks for all the information

I've already installed the specific patch but the problem persist...

Yes, it appens to all pc (4 in this moment) with different OS's (XP Pro, Server, Vista, ...); which is the patch you're talking about ? I didn't see anything on the IBM web site and our sellers didn't propose us nothing.

Hi all. I'm working with Sequence with more then 15 server job. Everytime I modify a trigger value, application crashes and return the following error: Application caused error dsdesign.exe, version 7.5.1.18, in the ntdll.dll, version 5.1.2600.2180, error address 0x0003426f. Can anyone help me to re...

Hi All, everytime I open the Administration tool and I click on Properties button there is a dialog with a warning:
DSR.ADMIN: Failed to enumerate local groups -
Can anyone tell me which is the problem and in which way can I resolve it ??

Thanks a lot

ray.wurlod wrote: Research the following statements in the on-line Help or in the DataStage BASIC manual:
OPEN
RECORDLOCKU
READU
WRITE
RELEASE
CLOSE

That should get you close. ...

Yes but I can't understand how I can create a new one...

Hi All. I've got a Before/After routine that get a set of information about the server job that recall it (number of rows, oracle error, name of the stage and so on). I'd like to store this information in an Hashed File (now I put then in a flat file) but I didin't find any specific command to creat...

I would heavily question your 'need' to do this. Why not a job if you need to do Oracle work? It is easy enough for it to be a 'pre-' or post-' job or even to do this inside your current job. I've been doing this a long time and have never had a need to fall back on this ODBC 'technique'. If this w...

Both of the code seems good but I need to connect to Oracle Database not using ODBC: is there a to connect to the Oracle table without it ??

In every case thanks!!

Hi All.
Does anyone know if is possibile to execute SQL statement inside an Before/After routine and which is the correct code ??
I've tried to insert the SQL statement but (Select ... From ... or Update...) but the compiler raise me an error.

Thanks in advance.

DSguru2B wrote:Well, you will have to get the eventid before the job starts, store it somewhere (COMMON, USERSTATUS, FLAT FILE etc) and get the last even id and then loop through each while getting the log detail.

That's fine. I'll operate in this way. It seems to be a good idea. Thanks.

More like, DSGetLogEntry() which works along with DSGetNewestLogId(). Look in the help index for DSGetLogEntry(), it will explain you how to use it. You will then have to create your own after job subroutine that uses these api calls. Thanks DSguru2B, I'm trying to use it but the problem now is tha...