DSXchange

Jim, When you specify the R option with the trim statement, you need to pick a value you want to -R-emove. Perhaps DS assumed that you wanted to remove nulls. Either way, I believe that the R option will never remove all characters in the string, it reduces to one occurance. I have successfully used...

Guillermo,

My off the wall guess is that the generated files are not trully empty or null. Check the files to verify that there is no white space on the first line,i.e. tab, space, nonprintable characters.
Perhaps your process is passing one blank field or record to the output.

Steve

Rasi,

Vladimir pretty well covered the answer. But put in shorter terms, the sort column in the aggregator stage is only for indicating that the incoming data is already sorted.

Steve

Not to be "nit-picking" but with the syntax you used to originally define these variables, they will be zoned numeric in EBCDIC and the first one will be char(9) and the second char(11). The lengths of 10 and 12 only hold true if you had stated that "sign is [leading/trailing] separat...

Viji, If your mainframe EBCDIC files are completely composed of character fields, then you should be able to just perform an ftp stage with mode set to ascii. Otherwise, you can follow Craigs advise and perform an ftp stage in binary mode into a transformer stage with output derivations of ascii(INP...

JB,

Have you tried to set the trace level to the max value. I know I've used the trace to find ftp errors in the past. Generates a large log, but will contain all the ftp transaction messages.

hope this helps,
Steve

Tony,

Thanks for the tip. It would be nice if we could do this from a hash stored in a directory path. We use some fairly large hash tables and prefer to clean them up from the UNIX side using a general cleaning script.

Thanks, it helped

Steve

ND, I don't think you will be able to do what your trying with a hash file. I may stand corrected after some of the more enlightened members chime in on this. To resolve your situation you may want to switch to feeding your transformer stage from a UV stage. With the UV stage, you can load it using ...

Morning,
Anyone using Informix temp tables in a DS project? Probably doesn't work, but asking anyway.[:D]

Steve

Andy, You could try a multirow lookup to a uv stage table containing the data: 1 2 2 3 3 3 ... This might work if your occurance field is limited and you can hard code enough data in the uv stage. You might have to add another field so there is something to carry into the lookup. If so then you coul...

Roy, There is a predefined routine that is close to what you are looking for. It's called weektag, located under routines/examples/functions. If you want to start your weeks with Sunday, then you will have to use your own code. The basis of the routine is that the internal date format is the number ...

Check the help Docs. for trim

Steve

Wolfgang, Thanks for the suggestion. The job I designed needed to perform a multirow lookup and reference to reference linking. The appearent problem is that DS ties itself to the Informix DB through one type of connection ( InformixCLI or ODBC ) and cannot establish a separate link using the opposi...

Tony,

Sorry for the long break (on vacation), I received word from Ascential that Informix and ODBC stages do not play nicely together. At least with DS version 5.2

Hope this helps,
Steve

Simon,

Have you tried to manually enter the derivation for the third column using your stored procedure? Maybe DS doesn't like the as clause.

Steve