DSXchange

Sorry.I have checked 4.1(it doesn't have). But.I saw the cmd (Name contains) like filter in DS v5.x but not work. I mean I wanna select the specific library tables that under xxxxx library from as/400 but it still find the DB2 system tables and give previous error msg. Actually,why do I wanna use th...

Sorry.I don't see this cmd in my DS Mgr.
I am using DS V5.x.Are u sure this feature included in DS 5.x?
Any other way to do this???


Thanks,

Hi guys,

Do u have any idea to filter the tables when we importing them from DS Mgr ???

OR

Is there any idea to reconfigure the ODBC setting from Datastage???




Thanks in advance,

coolhard

Dear All, I come back again.......... :idea: Still I have problem even I installed the DB2 Connect Enterprise Edition. Same problem(Searching DB2 system tables that not in AS400 anymore). When I check DS v5.x(now I wanna use) across with DB2 v7.x(old DB2 version),it works properly. But when I use DB...

Dear Ray, I am so sorry for my inconvenience to all of you. I really thank to u. Thank u so much for your time. Your comments are very useful for me. I am going to try to solve it and then I let u all know. BTW,my target db is AS400.ODBC cofiguration is DB2.So I believe your guess is very right. Tha...

Welcome aboard! :D Please check this post about why there is no such thing as "urgent" here. I would be very surprised if SQLTABLES does not exist; it is a system table containing information about all the tables in the database. It's more likely that you don't have SELECT privilege to th...

Welcome aboard! :D Please check this post about why there is no such thing as "urgent" here. I would be very surprised if SQLTABLES does not exist; it is a system table containing information about all the tables in the database. It's more likely that you don't have SELECT privilege to th...

My guess is that you were trying to import metadata, and the query to get the list of tables failed. Inability to do this usually means that your userid lacks the appropriate permissions in your database to select from certain system tables. I suggest you pursue your DBA and get the permissions. Ye...