DSXchange

Hi,
One way is to use the file pattern as your source rather then a specific file path.
search for it in the parallel job developers guide ( 5-28 ).

IHTH,

Hi, Maybe I or we misunderstood you? Is your case to have a central job that assigns parameters it reads from a file/DB to jobs you need to run? or do you need to phisicly insert the parameters to the jobs you run? the fisrt is easy to do the second might be more easy using parameter manager. So whi...

Hi,
You can try solving this in the sequential file's stage configuration.
this was covered extensivly please search this forum.
IHTH,

Hi, The Job Control functions are available when you write job control, i.e. a job written in basic code. In order to use theese routines in a transformer you need to to let the routine be known by the transformer. 1 way is to wrap it with your own routine (UtilityDSGetLinkInfo(...)) in this outine ...

Hi,
Any solution will make you test it yourself.
My sugestion:
use DS to generate a file with a valid insert statement and try running it in sqlplus it usually points you to the right column if you can't get it using DS.
IHTH,

Hi,
Under Routines\sdk\RowProc you can find similar routines that come with the product.
(at least for 7.5)

IHTH,

You need to distingwish 2 ifferent situations: 1. using the DataDirect provided ODBC drivers that can connect using the ODBC configuration as mentioned by Ray) 2. using the Informix CLI. the docs of plugin instalation and install & upgrade guides and the docs under the $DSHOME/../branded_odbc di...

Hi, As far as I remember you can perhaps get more info using array size of 1 fo debugging Or try to isolate the rows in question and try loading them directly using sql or dts to get the exact error (after you ftp the data to the sql server). Unfortunatly the OLEDB stage is not famous for clarity of...

Hi,
For starters you say

INFORMIXDIR=/home/inf930FC5; export INFORMIXDIR

F as in 64 bit client when you need the H version which is a 32 bit client on a 64 bit machine.

IHTH,

I know of a working location using RH AS 3.1
Arghhh... but then again if my memory serves me hey have the Server edition only
IHTH,

Hi,
Did you go thru the pre install requirements?
Did you go over the install logs to verify it was successfull?
Is the mentioned service number already used by another application?
If the problem is when connecting with the clients do you have a firewall killing the connection?

Hi, You can reverse the conversion again! Though I have used arrays as a return value from routines with no problem. If it is of any interest they can be passed as reference and besides the warning at compile time it works. As you want to use this in a loop activity I recommend finding a suiteable d...

Hi, I don't recall the process mentioned (copying libraries) being a formal supported installation of the Informix client! So you should first install the Informix client. Your MINFX seems to be the INFORMIXDIR but the INFORMIXDIR points else where try this first and post your new situation. IHTH,

Hi,
Is there any way to read this column as a numeric or a character type?
perhaps using a conversion function in the SQL itself?

(something like the to_char() being performed on oracle dates in the server jobs)

IHTH,

Hi and welcome aboard