×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Handling tables with reserved words/keywords in Informatica

Handling tables with reserved words/keywords in Informatica

Handling tables with reserved words/keywords in Informatica

(OP)
Hi All,
I am currently facing issues where table names are keywords/reserved words.

Database : DB2
Table Names : User, Template.

I have overriden the select query in "Source Qualifier" so while selecting data from source. Till this step everthing works fine while running the workflow.

But when we try to load the data in Target Informatica throws following error.

1. [IBM][CLI Driver][DB2/NT] SQL0204N "DB2ADMIN.USER" is an undefined name SQLSTATE = 42704

    I checked in target db, user table is present under DB2ADMIN schema.

2. I tried adding a Update Strategy Transformation in the mapping, so that we can override the SQL in target. After adding the manual query also Informatica is not able to load data.
Following is the error we are facing after adding the overridden query.
    
    Thread: WRITER_1_*_1
    Process ID: 32415
    Message Code: WRT_8118
    Message:
    ERROR: Target table [user] does not allow UPDATE
        Row # [1] in bad file

3. Template table is a system table as well and when we try to add a custom query in Source Qualifier we are getting "Table space access is not allowed" error, following are the details.
      
    Severity: ERROR
    Timestamp: 1/20/2011 10:33:14 AM
    Node: node01_PODETLSAPP01
    Thread: READER_1_1_1
    Process ID: 12348
    Message Code: RR_4035
    Message: SQL Error [
    Database driver error...
    Function Name : Fetch
    SQL Stmt : SELECT DB2ADMIN."TEMPLATE".CREATE_TIME, DB2ADMIN."TEMPLATE".CLSID, DB2ADMIN."TEMPLATE".UPDATE_USER_ID, DB2ADMIN."TEMPLATE".UPDATE_TIME, DB2ADMIN."TEMPLATE".CREATE_USER_ID,     DB2ADMIN."TEMPLATE".ELEMENT_NAME, DB2ADMIN."TEMPLATE".XML
    FROM
     DB2ADMIN."TEMPLATE"
    Native error code = -290
    DB2 Fatal Error
    [IBM][CLI Driver][DB2/NT] SQL0290N  Table space access is not allowed.  SQLSTATE=55039
     sqlstate = 55039
    ].

Please help. As i am stuck because of these 3 issues from 3-4 days.

Thanks
Amit

RE: Handling tables with reserved words/keywords in Informatica

sutaramit...

I strongly recommend you change the names of your Tables. Using/Naming any object with Reserved/Key words is an extremely bad idea, not only in Informatica, but for any System Development.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close