DSXchange

Hi All,

The default NLS we use is UTF-8,but there are some special characters in the in source file so I have changed the NLS to MS1252.Should I use the Same NLS1252 to my target(ORACLE) or use the default NLS UTF-8.

Any Help

Thanks
Pra

Hi Narasimha,

The length of Target field is 4000
Thanks
Pra

narasimha wrote:When you used Varchar as your target, what was the length you had specified?

Hi,
I have used Long in target but, I am getting the same warning

Thanks
Pra

I_Server_Whale wrote:Like in my previous post, where it explains the ORA error. Can you change the target field to LONG datatype and run the job?

Whale.

Hi,
The dataType for the field is Varchar in Job and TargetDatabase

Thanks
Pra

I_Server_Whale wrote:

chulett wrote:Datatype of the field in your job? Datatype of the target field in the database?

It will help if you provide answers for the above questions.

Hi Craig,

I have checked the dataType its Varchar.

Any Help

Thanks
Pra

Hi All, I am getting an ora warning,few fields in my file have huge text so I am using the SubString to limit the data to 4000Bytes Example: If Len(DSLink3.ASDFG)<=4000 Then DSLink3.ASDFG Else DSLink3.ASDFG[1,3999] The warning is: ORA-01461: can bind a LONG value only for insert into a LONG column A...

Hi Craig,

Thank's for your help.I will let them Know.

Thanks
Pra

Hi, Here is the sample record,I am putting the(|) symbol to differentiate between the columns 11 | 023 | F Customer observed smoke & a burning smell. Worn mixer motor with a locked rotor, and possibly an internal short circuit that burned a 10 ohm 1W carbon composition resistor on the EMC Motor ...

Hi Craig,

The Problem here is the first 15 records also have (,) in the data but the warning i am getting is from 16 record.

Any help

Thanks
Pra

Hi All, I am trying to read data from the CSV file using the sequential file,but there are (,) in the data also,and when I am trying to view the data the warning coming up is example..Sequential_File_193.DSLink195: nls_read_delimited() - row 16, column ENTRYDATE, required column missing example..Seq...

Hi All,

Thanks for your replys,the source file was not sent in a proper format.

Thanks
Praneeth

Hi DSguru2B,

Thanks for your response,not reponding means when i try to import the stored procedure meta data through the table definitions it is trying to retrive the meta data and after few mintues it shows not responding.

Thanks
Praneeth

Hi All, I am using the Stored Procedure Stage to call a procedure,When I try to Import the meta Data through the table definitions the server is not reponding.Is there any other way to call the stored procedure.I am using the windows OS or can I call the Stored Procedure in the After tab in the Orac...

Hi All, I am trying to read a file using the sequential file,the source file has 17 columns,out of these 17 columns 4 columns have chunk of data. When it try to view the data there are some warning messeges. example..Sequential_File_162.DSLink171: nls_read_delimited() - row 1, column productdisposit...

I have googled about WCS, can you explain more in detail Thanks praneeth To me WCS can have the following possible systems..don't know which one applies to your question :? WCS- Websphere Commerical Suite WCS - Warehouse Control System - applies to Warehouse in general or as Kenneth said World Class...