DSXchange

I've finally resolved most of those (I changed some fields defined as numeric that actually contained dates MMDDYY to timestamp in DataStage and to DATE in Oracle) except now I'm getting DataTypePic9: Error, unable to convert '. ' into number for 7 rows - but there's no event detail dialog box and n...

What's the best way to troubleshoot "ORA-1722 Invalid Number" errors? I'm writing to an Oracle table using the ORAOCI8 stage. The event detail dialog box in the log only shows the first 24 field values that I am converting (there are actually 51 field values in the file I'm converting), so...

Okay, now I have half the derivation accomplished with this derivation for writing to the DEBIT_AMOUNT column: If Data_In.CREDIT_AMOUNT < 0 then Abs(Data_In.CREDIT_AMOUNT * 100) ELSE Abs(Data_In.DEBIT_AMOUNT * 100) column but now I need to move zero to the CREDIT_AMOUNT column If Data_In.CREDIT_AMOU...

I'm processing a .txt file containing a debit amount and a credit amount (both numeric (15,2) and writing those two amounts to an Oracle table. The .txt file contains a sign on negative amounts, so when writing to the Oracle table I'm removing the sign with this derivation Abs(Data_In.DEBIT_AMOUNT) ...

I'm trying to convert a mainframe file from EBCIDIC to ASCII and it appears to be failing due to low values. What happens in DataStage when an EBCIDIC to ASCII conversion hits low values? What would be the resulting output - null? Zeros? The entire field may not be low values, for example: The conve...

Thank you so much - I was able to write linkname.DBMSCODE to the reject file.

I forgot to mention this is a conversion job (running one time) and the log info is to provide the reason for certain rows not being converted. The goal is to export the reject file to a spreadsheet to be filed, and it would be most helpful to include the reject reason in the spreadsheet, whether it...

Exactly where does this need to be placed? I'm trying to add it as a derivation in my transform so the value will write to my reject file into a column called LOG_INFO. I can't seem to get the syntax correct, or I'm just not putting it in the correct place within the job. DSGetLogEntry(DSJ.ME,DSGetN...

Unless I'm missing something in the log, the values being written to each column appear, but it is not evident which column(s) actually caused the error (e.g. value too large). For example, this is the text in the log: Jobname..TransformFiletoAscii: The value of the row is: ADDR_ID = 14049209 DATE =...

I have a separate reject link for three data files I'm converting to ASCII and inserting into Oracle tables. The reject file contains rows that were rejected due to several reasons, including the following: ORA-01401: inserted value too large for column DBMS.CODE=ORA-01401 ORA-01438: value larger th...

Unfortunately I'm on DS version 5.2. I'm using ORACOCI8 stages for the two Oracle tables I'm reading the dates from. The generated SQL is for the dates is TO_CHAR(linkname.LAST_RUN_DATE, 'YYYY-MM-DD HH24:MI:SS') and TO_CHAR(linkname.CREATED_ON, 'YYYY-MM-DD HH24:MI:SS') When I said I 'viewed' the dat...

So to compare an apple to an apple, my derivation should look like this? OCONV(ICONV(linkname.CREATED_ON, "D-YMD[4,2,2]"), "D-YMD[4,2,2]") > OCONV(ICONV(linkname.LAST_RUN_DATE, "D-YMD[4,2,2]"), "D-YMD[4,2,2]") I added a sequential file stage to write the recor...

I have a 'Created_On' column in an Oracle table (column defined as 'Date') in which the date, when viewed, looks like MM/DD/YYCC HH:MM:SS. I'm retrieving records from this file. I have a 'Last_Run_date'column in an Oracle table (column defined as 'Date') in which the date, when viewed, looks like MM...

Thanks - I changed the derivation and am running the job now - don't see any errors being logged - THANKS AGAIN!

I'm using an Oracle database 'view' as my source and the zipcode column is defined as varchar(35) in the view. Some zipcodes are 10 characters (xxxx-xxxx) but I only want the first 5 characters. Null zipcodes are not allowed (the target stage specifies the column as Null=N, as does the table I'm wri...