DSXchange

I am creating the flat files, and currently I am assigning a token negative number to signify a null value. This is easy to set in Datastage, just specify the "Null field value" in a sequential file step. However, knowing that Teradata has the ability to read presence bits to indicate null...

chulett wrote:I'm going to go out on a limb here and suggest you store them as... null values. Is there any particular reason why you wouldn't want to do that?

so how would you store a NULL value in a flat file?

Hello I am using Datastage Enterprise which will be loading data from flat files into a Teradata database. Some fields in the flat file will be 'NULL', and I am investigating the best method to store NULL values. One way is to use a token value (like -9999), but a better way would be to use the conc...

Hi folks, As part of my attempt to code-generate an osh-job, i have attempted to re-write a tranformer stage in Transformer-C, based on one designed in DataStage. It works, sortof, but the problem is the output fields are all jumbled up compared to the output schema the transformer is compiled again...

Yes, we have looked at RCP, but it doesnt seem to go well with transformers. There are certain field manipulations which have to be manually set for this to work.
Cheers

Yes thanks, i have all the environment vars sorted out. I just looked at what DataStage set them to, and used that, which worked.
Cheers

I realized the reject error is more of a warning, it doesnt stop the step compiling. I found the .so file under /tmp, is there an option somewhere that allows you to specify where the compiled object should go?

Hi, I am attempting to compile a transformer along the lines of the 'Orchestrate 7.5 Operators Reference', chapter 21, page 64. My code is a cut down version of their Example 1. When i try to compile, i get the followng output: ./test_transform.osh ##I TFCN 000001 09:59:36(000) <main_program> Ascent...

In the shared library search path; the set of directories specified by the LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH environment variable, depending upon your operating system. ... Yes, LD_LIBRARY_PATH works, thanks for that. I also need to set some environment vars: APT_CONFIG_FILE APT_ORCHHOME Any i...

[quote="jgreve"] How similar is "very similar"? Similar as in the logic is indentical, the only difference being the schema definition in the initial step (which is a complex flat file). The business problem is essentially reading in a series of flat files, performing some minor ...

Hello, When I attemp to run the osh shell: /opt/IBM/Ascential/DataStage/PXEngine.752.1/bin/osh I get the following message: ld.so.1: osh: fatal: liborchoslsun4.so: open failed: No such file or directory The file liborchoslsun4.so exists, ie: $ find /opt/IBM/ -name 'liborchoslsun4.so' 2>/dev/null /op...

Hi Folks, I am currently investigating the possibility of generating OSH script (and whatever else is necessary for a job to run) as an alternative to building many (hundreds) of very similar ETL jobs through the GUI. I need to know what needs to be generated (eg OSH, score, etc) and how such code c...