Search found 284 matches
- Thu Feb 20, 2020 9:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-01843: not a valid month
- Replies: 6
- Views: 7559
- Thu Feb 13, 2020 5:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-01843: not a valid month
- Replies: 6
- Views: 7559
- Thu Feb 13, 2020 9:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-01843: not a valid month
- Replies: 6
- Views: 7559
- Thu Feb 13, 2020 7:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-01843: not a valid month
- Replies: 6
- Views: 7559
ORA-01843: not a valid month
I have a strange issue wherein a query runs fine in TOAD, but not on Datastage Oracle connector, the job fails with error The OCI function OCIStmtFetch2 returned status -1. Error code: 1843, Error message: ORA-01843: not a valid month. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line 1,729) T...
- Sun Oct 20, 2019 2:41 am
- Forum:
- Topic: Error Linking Views In Information Governance Catalog
- Replies: 2
- Views: 3027
Error Linking Views In Information Governance Catalog
I am getting this error in Lineage Information for Information Governance Catalog The error occurs only for few views. Error linking view <ViewName> from schema <SchemaName>Error linking view View expression for ViewName is : I have tried re-importing all base tables in IMAM, also looked into Grants...
- Thu Oct 10, 2019 1:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Error message: ORA-08103: object no longer exists
- Replies: 3
- Views: 5049
- Tue Oct 08, 2019 1:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Error message: ORA-08103: object no longer exists
- Replies: 3
- Views: 5049
Oracle Error message: ORA-08103: object no longer exists
We have a scenario with two ETL jobs(Lets call them Job A and Job B) belonging to different subject areas with no dependency among each other, but operating on same table. job A has the following statement ALTER TABLE <TABLENAME> TRUNCATE PARTITION (PNAME) UPDATE INDEXES job B does a simple select *...
- Wed Jun 15, 2016 11:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting fastLoad script from Teradata connector
- Replies: 5
- Views: 5809
- Mon Jun 13, 2016 10:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting fastLoad script from Teradata connector
- Replies: 5
- Views: 5809
Getting fastLoad script from Teradata connector
I have a parallel job that loads data from sequential file to Teradata Database using Teradata Connector stage in Bulk/Load mode.
Is there a way to get the SQL query that DataStage generates to load the data in the table?
Is there a way to get the SQL query that DataStage generates to load the data in the table?
- Thu Jun 11, 2015 12:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing Header and Trailer record of a EBCDIC file
- Replies: 3
- Views: 3695
- Wed Jun 10, 2015 1:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Removing Header and Trailer record of a EBCDIC file
- Replies: 3
- Views: 3695
Removing Header and Trailer record of a EBCDIC file
I have a EBCDIC file and I am reading it using a Sequential File Stage and Schema File with RCP turned on. The multi layout file has a header record which is 21 bytes. The Detail records are 2427 bytes long and the trailer record is 9 bytes long. I managed to remove the header by using tail +22c in ...
- Wed Jun 10, 2015 1:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Optimization
- Replies: 4
- Views: 3590
- Mon Jun 01, 2015 5:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help to generate schema files dynamically for txt files
- Replies: 15
- Views: 10215
Read the file with a single column and then have a column import stage. In column import select option for schema file and have a parameter for the same. In this way you will have a single multi instance job but you will have 'n' schema file for n files. When you invoke the job just pass the paramet...
- Mon Jun 01, 2015 4:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job Optimization
- Replies: 4
- Views: 3590
Job Optimization
I have a job which reads from complex flat file and loads to an empty Teradata table. I am using Teradata connector with Bulk Mode (Load Driver). The table is multiset table and allows duplicates. It also has primary index. The incoming file is fixed width EBCDIC file with a row width of 7000 bytes....
- Wed Jan 28, 2015 11:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector Stage causing skew in Data Load
- Replies: 4
- Views: 6045
Hmm..Pretty much..The DBA team suggested to have a primary index on the table and for that choose a column with unique values..But this is already taken care off. The table already has a primary index. In fact the table has only 3 columns in all..Out of that two columns are always nulls and the thir...