DSXchange

I cannot seem to find an attribute for default column value in the Teradata Enterprise stage. I am looking under Output -> Columns -> Edit row...

Maybe it's not possible to specify default value for this stage type?

The (single) row only has two columns, both of which are Integer of length 10, which should result in only a few bytes. As for the number of nodes, I am not sure (I am new to parallel jobs, and at the same time new at site). An "APT config file" in use specifies two nodes, so I guess two i...

Thanks for the quick response.

Keeping the original NULLs from the database is exactly what I want to achieve. And the column is defined as nullable.

Am I missing something here? I thought it would return true NULLs as long as the column was set as nullable.

I am getting the following warning from one of my jobs: <Stage name>,1: Insufficient blocks for partition 1. Reading suppressed. The stage is a Teradata Enterprise stage reading only one row (max aggregate) from a table. The data (one row) is used in a lookup stage. The data (one row) seems to be re...

I am using a Teradata Enterprise stage to access a table, where one of the columns is of type Timestamp. When I run the job, I get 8 of the following warnings from the stage: <StageName>, 1: Data string ' ' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy...

Using DataStage 7.5.1.A on Oracle 10g: We have a server job which simply loads data from a view into a table within the same db schema ("manual" materialization of an oracle view). Like this: Oracle stage (view) -> Transformer with 1:1 mapping -> Oracle stage (table) When called within a n...

Only by putting the 'nextval' select into a lookup, from what I've seen. I have played around with that, but it is extremely slow. A minor speed test using 1000 000 input rows. Showed that - user defined sql had 20000 rows/sec - using a DB trigger to insert nextval about 9000 rows/sec - using looku...

Is it possible to set a column as seq.nextval without using user-defined sql?

I have done this using user-defined sql but it makes the server job a lot more cumbersome to modify.

Thanks for the input it is an interesting solution that would work. But combining two solutions I do not really want to use with routines kind of sums up what I do not want to do. The real problem is not doing it, but making it as easy to understand as possible while still keeping it quick to change...

vpauls, I'm not sure I understand what you mean by "schema" in this context. Does this mean the job itself is on different servers with different userid/passwords? Or that the job runs on one machine, but you login to different database schemas? Or something entirely different? Sorry if I...

Hi. We are trying to make a server job iterate over several shemes. Logging into a specific scheme is done by username and password alone. We have currently come up with the following methods. 1. One seqence where the job is calles 1 time per scheme with hardcoded username/passwords. Works but is no...

I mean DSN, sorry. When I try to import the datadefinitions I get an import window that among other things asks for a DSN in a pull down box. When I try to open the box to choose DSN I get the error message: "Empty DSN: list returned from host XXX.XXX.XXX.XXX". I assume that this is becaus...

Yes I have and I can when importing table metadata, but when trying to import stored procedure definitions it wants to have a dns and it isn't provided from the server.

/Elin

Thanks for your answer!!

When I ran it the reply was "number not correct" and it aborted. Now I'm using a table with many rows but I have said that the procedure should only be run once for the job, but it is taking a very long time. Last time I ran it using a oracOCl stage writing one line to /dev/null and before...

Hi, I am trying to use the stored procedure stage in DS on an already existing job but I'm having problem with the input. Before I used dual and a dummy row and wrote to a /dev/null file and the executed the procedure in the before sql clause. Now I want to use the store procedure stage instead. Tha...