DSXchange

check the SQL type for all the output stage columns... Make sure that character column from SELECT statement is not getting loaded in the numeric output column.

try same query using SQL Plus...Does this query run properly on SQL prompt ?

What is the definition (SQL type, length and scale) of input and output columns ?
If output column is declared Numeric without scale specification, then
Abs(-12.56) returns 13.00
If proper scale specified, then
Abs(-12.56) returns correct value.

If value by which you want to multiply aggregator results is one column, one row output of the select query fired on oracle table table2 and input data is in table1, then 1. When you select data from table1, select value from table2 also... so, that output of select query will have all required colu...

Then, why not use UNIX command to list the filenames and redirect output in the text file? You can use this text file for further processing.

what about the non-key column ( outputs/columns tab) details ... the column which receives the contents of the file ?

write routine something like this : ========== var1 = BRANCHECODE var2 = BOEKMAAND var3 = MUTATIECODE If (var1 = 1 or var1 = 2) and var2 >= 0 and var3 = 1 then Ans = var3 end else Ans = 0 end ========= where Routine Arguments are BRANCHECODE, BOEKMAAND and MUTATIECODE ========= U can modify this rou...

What is the defined SQLtype and length for 'Record' column (i.e. non-key column) on the FOLDER Stage --> OUTPUTS --> COLUMNS tab ?

Hi, Job design includes perl program which calls two jobs in serial... First job reads couple of seq. files and Redbrick database tables ..creates output sequential files. These files are used as a input by second job. Second job reads these files and loads redbrick table. Perl program uses dsjob co...

Hi !
Want to know system requirements for installing datastage client on WIN and server on Unix box...

Anyone has any info./doc regarding orabulk.... ??

facing a problem with oracle 8.1.6 odbc driver and datastage 4.2 combination ... ODBC driver problem... Is this oracle and datastage version compatible ?