DSXchange

I am getting below error while reading a Fix Width File:

Bad record delimiter after fixed-length record: expected "\n", got " "

Record length in my File seems to be okay and is matching with Schema file.

Any idea?

Thanks for the reply. What should be the ideal setting for purging in order to resolve the issue?

I am running a Multi Instance Datastage in a loop by passing different parameters at run time sequencially using Unix Shell Script and DSJOB -run command. After running 4 to 5 iterations its gets out of loop and aborts. Does any one has any idea, is it related to some datastage resource issue. Below...

Its working now. I used DSSendMailTester inbuilt routine.

I tried below in DSSendMail routine. Its sending email, but its not sending the content of file in email body

"From:atul@xxxxxx.com\nTo:atul@xxxxxx.com\nSubject:Hi ya\nAttach:/app/bb5g_etl/ATUL/email.txt\nBody:\n Execute_Command_1.$CommandOutput"

Thanks for the reply. Is it possible to share the sample routine which can send the output of text file in Email body.

Hi,

How to send output of Query Result in the email body using datastage.

Example: I write the output of a query in a text file. Then content of text file or directly output of query, I want to send in Email Body

Thanks
Atul

Hi Pranita, Do you find the solution for your problem. I am also having the same issue.

Yes I agree your point Craig. I have made the columns as NULLABLE on Oracle and loading the data. Thanks.

Its a empty value in a column. I found that Oracle treats NULL and EMPTY values as same (NULL)

below link explains that:

https://stackoverflow.com/questions/132 ... -in-oracle

So there is no option to Load EMPTY value in Oracle from Datatsage in NOT NULLABLE column.

I am reading the data from SQL Server and dumping into Oracle. I am using RCP while reading and writing. For reading and Writing both I am using ODBC connector stage. Problem is, there are some NOT NULLABLE columns having EMPTY values in source and the job is getting aborted while loading these EMPT...

I am able to read it properly using server sequential file stage but the issue is I have many files to read. In server job I cannot pass schema file name. I have to hardcode the column names in server sequential file stage. So i cannot use single job to read multiple csv file. Can you suggest some o...

Hi, I have a data like below in CSV file: 1,N,"AAAAA L,BBBBBB R","CCCCCC DDDDD"" AAA FFF","NO 55""",FSFSFSD CVCVC 1 Column: 1 2 Column: N 3 Column: AAAAA L,BBBBBB R 4 Column: CCCCCC DDDDD" AAA FFF 5 Column: NO 55" 6 Column: FSFSFSD CVCVC Ca...

Hi. I have resolved the issue. while using cast function in source sql we were defining the length of varchar less than the actual length in As400(Source DB) In Source length was 13 and I was reading it like CAST(BIAMT AS varchar (10)) AS BIAMT I increased the length to 142 and its running fine now....

And I am getting this error with BIAMT Column ODBC_Connector_0,0: Fatal Error: Attempt to setIsNull() on the accessor interfacing to non-nullable field "BIAMT". Also I have tried running the job by manually defining the column in column definition and marked the nullability to yes on ODBC ...