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?
Search found 82 matches
- Tue Jun 02, 2020 1:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fix Width File read Error
- Replies: 1
- Views: 15013
- Wed Sep 04, 2019 8:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job aborting with Return Code :255
- Replies: 4
- Views: 6479
- Wed Sep 04, 2019 8:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job aborting with Return Code :255
- Replies: 4
- Views: 6479
Job aborting with Return Code :255
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...
- Fri Aug 17, 2018 3:09 pm
- Forum: General
- Topic: Query result in Email Body
- Replies: 5
- Views: 5065
- Fri Aug 17, 2018 3:02 pm
- Forum: General
- Topic: Query result in Email Body
- Replies: 5
- Views: 5065
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"
"From:atul@xxxxxx.com\nTo:atul@xxxxxx.com\nSubject:Hi ya\nAttach:/app/bb5g_etl/ATUL/email.txt\nBody:\n Execute_Command_1.$CommandOutput"
- Fri Aug 17, 2018 2:39 pm
- Forum: General
- Topic: Query result in Email Body
- Replies: 5
- Views: 5065
- Thu Aug 16, 2018 12:40 pm
- Forum: General
- Topic: Query result in Email Body
- Replies: 5
- Views: 5065
Query result 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
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
- Wed Aug 08, 2018 8:34 am
- Forum: General
- Topic: Problem with execute command activity in sequence job.
- Replies: 9
- Views: 7688
- Thu Nov 30, 2017 6:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading EMPTY values in NOT NUllable column
- Replies: 4
- Views: 4874
- Tue Nov 28, 2017 7:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading EMPTY values in NOT NUllable column
- Replies: 4
- Views: 4874
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.
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.
- Tue Nov 28, 2017 2:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading EMPTY values in NOT NUllable column
- Replies: 4
- Views: 4874
Reading EMPTY values 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...
- Fri Sep 08, 2017 9:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Double quotes in CSV file
- Replies: 7
- Views: 9285
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...
- Fri Sep 08, 2017 3:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Double quotes in CSV file
- Replies: 7
- Views: 9285
Reading Double quotes in CSV file
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...
- Thu Jun 15, 2017 5:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Attempt to setIsNull() on the accessor interfac
- Replies: 13
- Views: 10515
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....
- Thu Jun 15, 2017 12:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error: Attempt to setIsNull() on the accessor interfac
- Replies: 13
- Views: 10515