Search found 144 matches
- Tue Sep 17, 2019 1:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [Complex Flat File] Reading Complex Delimited File
- Replies: 3
- Views: 3912
[Complex Flat File] Reading Complex Delimited File
Hi everybody. I need to find a solution to read a complex file, delimited by ';'. Imagine the following layout: Document;QuantityPhone;PhoneNumber;PhoneNumberArea;QuantityEmail;Email;EmailStatus 111111;1;8888-8888;11;1;test@test.com;Valid 222222;2;7777-7777;11;6666-6666;11;1;test@test.com;Valid 3333...
- Thu Aug 22, 2019 9:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [File Connector] Wrong Date recorded on HDFS (month October)
- Replies: 2
- Views: 2985
It is so weird, man. We think that it might be the Java version. But when I set JAVA_HOME variable at the job, sometimes it works at the first running. However, the other result executions are wrong. When I copy the job and execute it for the first time, it works. (the following executions record th...
- Mon Apr 01, 2019 11:51 pm
- Forum: General
- Topic: Is File connector able to read orc partitioned files
- Replies: 4
- Views: 7158
- Mon Apr 01, 2019 1:14 am
- Forum: General
- Topic: Is File connector able to read orc partitioned files
- Replies: 4
- Views: 7158
Re: Is File connector able to read orc partitioned files
Hello.
Did you find any solution for this issue?
I read txt file from HDFS using File Connector and have the same problem.
Actually most of times, I just rerun and it works perfectly - without any other action.
Thank you so much.
Joyce
Did you find any solution for this issue?
I read txt file from HDFS using File Connector and have the same problem.
Actually most of times, I just rerun and it works perfectly - without any other action.
Thank you so much.
Joyce
- Wed Feb 27, 2019 7:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [File Connector] Not delimited Files
- Replies: 10
- Views: 6895
- Wed Feb 20, 2019 2:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [File Connector] Not delimited Files
- Replies: 10
- Views: 6895
- Mon Feb 11, 2019 11:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedures in Oracle connector stage
- Replies: 13
- Views: 20524
This approach worked fine to me! (the only one)narasimha wrote:The below should work for you. Note the semi-colons.
Code: Select all
BEGIN DBMS_STATS.gather_table_stats(XXXXXXX); END;
Thank you so much.
- Thu Feb 07, 2019 2:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [File Connector] Not delimited Files
- Replies: 10
- Views: 6895
Oh nice, Ray. I am still having problems. Actually I read that you can configure the properties of the 'File Connector' the way it can understand the fixed width of the fields: * File format: implicit * Record definition: Delimited String * Definition source: <name>:<definition>[length] Between each...
- Wed Feb 06, 2019 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [File Connector] Not delimited Files
- Replies: 10
- Views: 6895
- Wed Feb 06, 2019 1:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [File Connector] Not delimited Files
- Replies: 10
- Views: 6895
[File Connector] Not delimited Files
Hi everybody. I am using 'File Connector' object to read txt files from HDFS. but some of them are not delimited, fields are positionals. Example: JoyceRecacho34 years oldBrasil In other words, it would be like: Field1: Row[1,12] Field2: Row[13,12] Field1: Row[25,6] ======= I noticed that using the ...
- Fri Nov 30, 2018 2:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [Clustered DataStage] ORA-01950: no privileges on tablespace
- Replies: 2
- Views: 2612
- Mon Nov 26, 2018 10:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: JDBC Connector Exadata - failed to locate a suitable driver
- Replies: 2
- Views: 3576
- Tue Jan 30, 2018 1:13 pm
- Forum: General
- Topic: dscmdexport domain?
- Replies: 11
- Views: 4756
- Sat Jan 27, 2018 4:47 am
- Forum: General
- Topic: dscmdexport domain?
- Replies: 11
- Views: 4756
- Wed Jan 24, 2018 3:24 pm
- Forum: General
- Topic: dscmdexport domain?
- Replies: 11
- Views: 4756