Trying to execute the below SQL from an Oracle Connector stage fails with ORA-00942: table or view does not exist.
Yet, it works fine in view data?!?!
We strongly suspect NLS mismatch with runtime environment variables.
The Oracle 11g DB we're connecting to has NLS Settings, soL
LANGUAGE = ENGLISH
TERRITORY = UNITED KINGDOM
CHARACTER SET = AL32UTF8
Can anyone advise what the Paralell Map should be? Is there a need for a user defined env var of NLS_LANG? of what value?
Has anyone encountered similiar?
Many thanks for any suggestions
SELECT 'record' from dual
UNION ALL
SELECT ' {final_delim=end, record_delim_string=''\n'', delim='','', null_field='''', quote=double' ||
DECODE(CNT,0,'}', ', timestamp_format=''%dd/%mm/%yyyy %hh:%nn''}')
FROM (SELECT COUNT(*) CNT from all_tab_columns where table_name = 'ADDRESS' and data_type like 'TIMESTAMP%')
UNION ALL
SELECT '(' from dual
UNION ALL
select *
from (
select
' ' || column_name || ':' ||
DECODE (NULLABLE,'Y', 'nullable ') ||
DECODE(data_type, 'VARCHAR2', 'string[max=' || data_length || ']',
'NUMBER', 'decimal[' || data_precision || ',' || data_scale || ']',
'FLOAT', 'sfloat',
'TIMESTAMP(3)', 'timestamp', 'string'
) || ';' file_row
from all_tab_columns where table_name = 'ADDRESS' order by column_id
)
UNION ALL
select ')' from dual
Oracle Connector and NLS?
Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 33
- Joined: Tue Nov 06, 2007 1:09 pm
Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration