DSXchange

I found the problem. I was doing a conversion on a Nullable Timestamp. It would not write to the dataset. Would someone know the logic to ignore timestamp conversion if Null. I tried the following and can't seem to get it to work IF IsNotNull(TimestampToString(DSLink13.REGISTRATION_DATE,"%yyyy-...

I am trying to write one record to a dataset and the stats show 1 record being passed to the stage but I can't view the records. The job does not abort. I removed all null possibilities thinking that was the problem, I started all debug option and still can't find out why the records are not written...

If the Excel file resides on your desktop and DS reside on a server, can I use ODBC to access the file on my desktop or do I need to FTP the file to the server.

I looked at ODBC stage and when it request Source in the properties field, is this where you enter the path and filename.

Thanks

Hi Vince,

Jobs that compiled before we upgraded to 8.0.1 worked. Now they are aborting.

I received the following message during a compile (Transformer included) ##F IIS-DSEE-TUXX-00001 16:29:35(000) <main_program> Internal Error: (numInputsKnown_): api\operator_rep.C: 2611 (LOAD_ATTRIBUTION_DIM.Transformer_19) the compile ENV value is -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c and the Li...

For 7.5.x2 version, Visual net 2003 is the preferred compiler. 7.5.x2 was specifically designed for that version and all later versions do not work. Once you get to 8.0.1, the latest version works.

I am moving information from an Oracle operational system to a staging area. Using DataStage, what is the most efficient way. I would assume it is with the Oracle bulk loader but I can't seem to get it working. I got this error when I tried to write, Load_StgInstrument: Error when checking composite...

One of the jobs in a sequence aborted. At the same time, there were multiple jobs running. All running jobs ended up in a hung "running" status. They did not complete and could not be stopped. The job sequence has an exception handler and terminate activity stage. What is the functionality...

I used the metadata import facility to import the Oracle metadata. When importing timestamp types, they are converted to date types. If I use the Orchestrate import, the metadata is imported correctly. The problem is, I have many tables and the orchestrate import one table at a time. Is there someth...

So far everything is working great. Thanks so much for your input.

Is there a way to avoid re-compiling DS jobs when a parameter set value is changed. The parameter sets were created to avoid environment changes when jobs are run in different environment. For some reason, when the value is changed in the parameter set, the job must be re-compiled to pick up the cor...

I am passing rejects to a sequential file stage. Is there a way to setup the Null handling for Null fields. Unlike the non-rejects, where I can apply Null handling, rejects do not write to the file and I can't seem to apply Null handing to the fields.

Thanks

Thanks, the problem was with the Null values. I had to handle them in order to avoid rejects.

I must elaborate more. The reject link is on a Lookup Stage, not the write sequential stage.

Yes I have a reject link and as well, the record are rejected when writing to the file. I thought it was a permissions error but the file has fill write access.

I will try varchar but if you want numerics or any other formats in your sequence file, it kind of defeats the purpose.