DSXchange

Is this a fixed width file or a delimeted file? One option I see from your data is take the whole string in one column and use substring to strip first 8 charecters and then convert it from string to date Fixed width - record length 49 - what stage would I use to substring and parse the record? - t...

The numeric is read as a char and, converted to a signed numeric in the modify stage. The issue is that the date fields (which is read as a string) starts at the 0 of 2013 instead of the 2

I have a 3 field sequential file: Extract_date CHAR 8 ID CHAR 11 NAME NVarChar 30 Modify stage converts Extract_date to Date with: Date_From_String(EXTRACT_DATE) Date format String = %yyyy%mm%dd input record like: 20131121+0000448416CHARLOTTESVILLE<spaces to rec end> Error Says: Unhandled conversion...

I checked with other teams at my installation - they've all had the same issue. They performed the research and tried multiple combinations of file types/mappings/extension to no avail. The work around was/is to use a "C" program to read each file, rewrite all recognizable/printable charac...

no need to 'Reply with quote' each and every time. However, when you do you cannot have 'Disable BBCode in this post' on by default. It doesn't work so well when you do. I usually clean up stuff like that but left yours alone so you could see what I meant. [Note - I couldn't stand it so I fixed it! ...

I set the type in Oracle to varchar2(65 CHAR) and still get the errors. Any thoughts? First thought - please don't send email to us for help, if and when people have something more to add to an issue, don't worry - they will. I don't have any additional thoughts on the 65/67 issue at the moment. Th...

Thought id'ed try something - I imported the Oracle table definition (after I altered the table to varchar (65 char) ODBC definition as follows: SQLType:NVarChar Length:260 Display:8 File stage for flat file: SQL Type:Char Extended Unicode, Length 65 Modify StageL (i/p): SQL Type:Char Extended Unico...

the record in question (2 of 3 below) seems to read longer than the char 65. You will note the abscence of the last field (i.e., the FC in Recs 1 and 3): 20130320 009426 +00009 +00009 CASOSCARI ISTITUTO D'ARCHITETTURA FC 20130320 009427 +00007 +00005 JULIUS-MAXIMILIANS-UNIVERSITðT W²RZBURG 201...

Performed "Alter" statement and made column varchar(65 Char)" type
Reran job:
File stage char 65 unicode
Modify stage char 65 unicode (i/p) - char 65 unicode (o/p)
ODBC Insert into ..... (target varchar(65 char)

ok - heres the new scenario(s): Changed each occurance of field in question to unicode - job ebended. All records rejected - following warning: "External ustring too long. Imported only 65 of 67 external charaters into a ustring of fixed length 65. Ignoring last 2 charaters of ecternal ustring ...

In Oracle - it is VArchar(65) -- Byte or Char not sure - will check with DBA

Thanks

Thanks -

So everywhere that field exists in the job - activate unicode?:
Input file stage
Modify stage (as a pass through column)

I am reading a flat file from IBM/DB2 - The layout has each field fixed length CHAR. There is a Char(65) field that has characters that look not to to be English (European maybe). Anyway - In the log Iget a "buffer overrun" warning, the next field in the sequence shows no data and I get an...

Thanks for the quick responses (and yes typo on EBCDIC). I was using wrong options (Format Tab > Record Delim String was "DOS") and Column SQLTYPE changed to mix of Char and VarChar

Thanks guys !!

When I use a Sequential File Stage - generates errors and warnsing that seem to be based on no \r\n at end of each record When I use a CFF fixed\EBCIDC generated error on 1st record : ##W IIS-DSEE-TOIX-00175 13:17:58(000) <stagename> Source subproc: /opt/ibm/iis/Server/Projects/D2I/SrcFiles/NSLDSP_L...