DSXchange

I have a file with 10 fields. When the fields exist the file record is 100 bytes. Sometimes the last field is missing, sometimes the last 7 fields are missing and everything in between. I don't care if these are missing but it's causing problems for the Sequential file stage. What can I do to read t...

ray.wurlod wrote:It probably also needs to be mentioned that the runtimes must be 100% compatible with the compilation environment. ...

Just to clarify, you're saying the C++ runtime environment in production must match the C++ compiler/runtime environment in development?

You should have devised an ETL framework that supports transportable code across environments. The two most obvious methods are environmental variables utilized by the jobs at runtime or intelligent job control that derives parameter values for jobs at runtime from tables, environment, and or confi...

In DataStage Export GUI you will see Job Designs, Executables and so on (its obvious). You select there. Ok, I'm clicking through the GUI and can export an individual job or a set of jobs under a folder. My question from my previous post is really coming from the perspective that I would like an au...

1) This is the part I need the most help on. Would I need to go through each job in Designer to compile/export? Is there a Unix command to compile/export these jobs? Where are the job designs/executables stored so I can pick them up? If parameters change from DEV to TEST/PROD, how are you getting ar...

In the documentation that i've read, it appears possible to compile jobs on one machine w/ a C++ compiler and deploy to other machines with the C++ runtime and no compiler. Also, some folks I work with were lucky enough to go to the training class. though it did not cover a development/deployment se...