DSXchange

That is not correct. The routine type must be before/after. You can store it in any category you please. ----- Original Message ----- From: "Simon Fryett" Date: Mon, 06 Jan 2003 14:54:11 +0000 To: datastage-users@oliver.com Subject: Re: Calling KeyMgt* from routine > Hi Tom, > > to make a routine av...

Hi all,

I am running a simple job on DS 5.2 to read a sequential file and update
Informix table using Informix plug-in.
The job does update the table but completes with a warning message:

This data source does not support transactions.

Any thoughts?

Thank you,
Leonid Frumker

Hi, You are probably better using target = CONVERT(CHAR(10):CHAR(13),:,source) as this results in only one BASIC function being called per column/row if performance is an issue although I have not verified this. Phil Walker Altis Consulting Limited Australasia > -----Original Message----- > From: De...

Hi Tom, to make a routine available for before and after usage it must exist in the before / after folder in the routines section. Simon. p.s. see my previous note .... >From: tom.peter.nielsen@nordea.com >Reply-To: >To: datastage-users@oliver.com >Subject: Calling KeyMgt* from routine >Date: Mon, 6...

Hi, Just a quick thought about this problem, If a routine that is called in the before / after section returns a non zero then it is deemed to have failed and so the datastage job at that point will stop. I believe the key management routine will virtually always return a non zero. Hope this helps S...

Yes, that might be the reason! But what is with you function, when you make it as a transform function? But perhaps you let us know, what you want to do with the result of the function and then we may tell you if it does make sense or if there other ways for getting the same result. Wolfgang > -----...

SDK routines seem to be cataloged with the prefix DSX rather than DSU, and also in upper case. Try: deffun KeyMgtGetNextValue(a) Calling "DSX.KEYMGTGETNEXTVALUE" > -----Original Message----- > From: tom.peter.nielsen@nordea.com > [mailto:tom.peter.nielsen@nordea.com] > Sent: Monday, January 06, 2003...

Test is disabled even when it compiles without any errors or warnings. Could this be the because im making an before/after routine ? Im also including 4 other files, could that be the reason that i can test ? $INCLUDE DSINCLUDE DSD_STAGE.H $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE DSINCLUDE DSD.H $IN...

Hi Tom, do prefer the Routine "KeyMgtGetNextValueConcurrent" instead of "KeyMgtGetNextValue". In the Manager push button "TEST". What happens? Does it work? The function writes to a file for to save the last value, maybe you dont have any access rights to the path of the file. Wolfgang > -----Origin...

Hi, Any idea how i can call the SDK routine "KeyMgtGetNextValue" from my Before/After Subroutine ? Ive tried to define it as a user routine, but without luck. entered this line: deffun KeyMgtGetNextValue(a) Calling "DSU.KeyMgtGetNextValue" But it didnt work, it compiles fine, but the program aborts....

We got it: change(change(string,char(10),""),char(13),"") Thanks guys! -----Original Message----- From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de] Sent: 06 January 2003 10:31 To: datastage-users@oliver.com Subject: RE: bold free text field Hi Denzil, to know, what is in between...

Use EReplace function. Check help on its usage. YN --- Denzil Sander wrote: > Excellent. It is a "0A" (LF) character. > Does anyone know the change/replace cmd I can use to > replace the LF > character? > > -----Original Message----- > From: wolfgang.huerter@gerling.de > [mailto:wolfgang.huerter@ger...

Excellent. It is a "0A" (LF) character. Does anyone know the change/replace cmd I can use to replace the LF character? -----Original Message----- From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de] Sent: 06 January 2003 10:31 To: datastage-users@oliver.com Subject: RE: bold free t...

We will be scheduling an upgrade to the forum this week to resolve this issue.

Hi Denzil, to know, what is in between, you should use a HEX-editor and with such a tool you see, what is in between. In Windows you have CR and LF between lines CR= cursor return LF= line feed CR is Ascii "13" in dec or "0D" in hex LF is Ascii "10" in dec or "0A" in hex In Unix you only have line f...