DSXchange

Wanted to add to this thread since I was just wrestling with a similar error and wanted to make it perfectly obvious to future seekers that sequential files in EE DO NOT LIKE FIELDS DEFINED AS CHAR !!! I received the following error: Bad trailing quote character at field "COLUMN_ONE"; look...

Hello all, I just modified a couple of jobs that had passed my unit test. I needed to rename a couple of links to adhere to standards. Suddenly, errors started popping up. - At compile time, my conditional lookup constraint caused an error. DataStage did not rename the link name in the link. Server ...

Can we write user-defined queries in a teradata stage when teradata stage is acting as destination. Hi ssunda, What type of TD stage are you using? If it's the enterprise stage, you can specify on your 'Properties' tab, in the 'Connection' branch a 'DB Options Mode' property. Set this to 'User-defi...

Actually, it's weirdo not wierdo.

Rob Wierdsma

Thanks for the clarifications, gents

Rob

Now I do not have a record delimiter as none of the records have a newline at the end of the record. What should my record delimiter be as I have tried null and none. I am out of ideas. Please help me. What character(s) are used to distinguish the different records in your file? I.e. when you open ...

Thanks for the additional info yakiku, I'm sure this is going to come in handy!

Hi RAJARORA, Which stage are you using, the TD Enterprise or TD MLoad stage? There are some issues with the Enterprise stage needing to create a temporary table in the same database as the target table in order to get parallelism happening. If your user id doesn't have create privileges, the enterpr...

Folks, I just had an interesting conversation with one of the other developers here on the topic of Basic Routines in a parallel job. I am aware that if I were to include a Basic Transform in a parallel job, the job would only ever be able to run in a SMP environment, not in a MPP environment. Is th...

chulett wrote:Well, keep the technique in mind for those times when you can't do the aggregation in the source database - times where you are aggregating on transformed data, for instance.

At these times, you can still use the database to do your sort - do as much work up front in the RDBMS as you can.

Rob

I'm starting to come to the realization that I cannot perform any aggregations on non-numeric columns in the aggregator stage :!: Is this true :?: I'm trying to do a vertical pivot. Many of my columns are numeric and I can get the surviving value by doing a Max, however, aggregator is choking on all...

This is a little surreal; I just now needed to do the same thing, and got the same error. Thanks, Arnd, for your idea. I had only a date, not a date time, so I converted to an integer using: DaysSinceFromDate("1900-01-01",From_DB.SNAP_DT) and went back again using: DateFromDaysSince(To_DB....

In the original post you refer to the timestamp being fine. Are the date and time two different fields or have you truncated the timestamp component in your example? We had a similar problem (not in DB2) where the query tool was rounding off part of the timestamp, causing the date to get incremented...

SPlayer, I'm running 7.5x2, and this is how I can get at the pad character property - Go to the Columns tab of the properties of the sequential file stage - double click on the row number column (the grey column with a number) - highlight the Integer type or String type branch in the Properties box ...

I would add that you need to remember in your estimates that PX jobs WILL take longer to code.

The server transformer stage was like a Swiss Army knife, now you have a whole drawer full of utensils, none of which do everything the Swiss Army knife did, but will do each individual task better.

Rob