DSXchange

Hi all,

Is there any function or routine which will reverse a string?

For example abcdef has to become fedcba.

Regards

Josy

Hi All, Please, could somebody give me some details about DSRMessage. I would like to know the meaning of the arguments passed to it. I can't find any documentation concerning that topic. DSRMessage("DSTAGE_TRX_E_0011", Message = "No command to execute.", "") For instan...

Is there any way to avoid all these warnings?? I was expected to get only one warning indicating that N rows have been rejected. No. Your Target stage is generating the error messages and it will do so regardless of the presence of a Reject Row. All the Reject Row does is allow you to capture the r...

Hi All, I am trying to design a job to trap my database rejected records like that : SourceStage----readlink---->TransformerStage-----insertlink----->TargetR SourceStage----readlink---->TransformerStage-----insertlink----->DBMS rejectlink SeqFileStage So, I have checked the box "Reject Row"...

Ray, I have tried the command CONNECT I managed to connect to the DataSource but I did get the following error message when i tried to execute any sql : [ODBC:1509] [DataDirect][ODBC DB2 Wire Protocol driver]File not found 'IVVM.LIC'. Additional error info: Status = -1 SQLState = S1000 Natcode = 606...

Hi all,

I would like to test an ODBC connection on UNIX.

So, does anybody know where I could find an ODBC query tool for UNIX?

Regards

Josy

Thanks everybody!
We have not yet solved our problem!!
But I think I am going to check with the AS400 team if they have any way to debug my process.


Regards

Josy

An example of user defined sql I am trying to run is :

DELETE FROM hmlimsnra.MILOCK1P WHERE (MLKEY = ?);

Regards

Josy

I already used the question mark! And I already tried having the Stage create 'normal' SQL and then switch it to User Defined. But the funny thing is for the same statement: - when I use the 'normal' SQL, it works - when I switch to the User Defined sql, it hangs. That is why I am a bit confused. An...

I don't have any parameter like that on UNIX.

Thanks anyway

Josy

Here is an example of the SQL I am trying to execute :

DELETE FROM HMLIMSNRA.MILOCK1P WHERE (MLKEY = 2);

An update would be

UPDATE HMLIMSNRA.MILOCK1P set MLKEY=3 where MLLOCK=6;

Regards

Josy

I have already changed my .odbc.ini file to activate the tracing.
There is nothing concerning the SQL statement in the trace file and actually the trace file does not help me at all!:-)

Regards

Josy

All, I am trying to delete data on AS400 files using the ODBC plugin. But it appears that when I run the job using User-defined SQL, it hangs and does not delete any data. However, when I run the same job using the update action "Replace existing rows completely", it works properly, which ...

Hi all,

I am trying to delete data on AS400 using an ODBC connection.
But it seems that my job is only committed the transaction at the end.
So, the process is locking the whole AS400 file.
I tried to change the isolation level but no results.
Any ideas...