DSXchange

Yes it is an authorization issue........

> Select * From PRISMPH/PMODEL
Not authorized to object PRISMPH in QSYS type *LIB.

Thanks

This is what i get..........

>Select * from PRISMPH.PMODEL
Qualified object name PMODEL not valid.


But I could import table definitions from PRISMPH.PMODEL......so it is a valid object name.......

Mat, I got the connectivity working and i could import table definitions.......but when i run an extraction job..........its errors out saying "QSYS.PRISMPH DOES NOT HAVE PRIVILEGE TO PERFORM OPERATION TABLE ON THIS OBJECT(null)" Is it some security issue pertaining to "Select" a...

Laurel,

what do i have to fill in for

Package=??
Location=??? (Is it the remote database name??)
Collection=??? (Is it the library names to be filled one after the other???)

Thanks
Prince.

mat, After fixing the username/password issue. i get ......... ./bind20 PRISMDB2CONNECT Packages created and bound Now i'm trying to test the ODBC Connectivity and i get the following error... >DS_CONNECT PRISMDB2CONNECT Enter username for connecting to 'PRISMDB2CONNECT' DBMS [dsadmin]: c408260 Ente...

Mat,
i looked it up....

7676 : user/password invalid.....

Thanks very much

PJSimon

Mat,

Now i get...

Package Creation Failed!:7676

Do u know what this error code means???


PJSimon.

mat, This what i get...... $ ./bind20 PRISMDB2CONNECT exec(): 0509-036 Cannot load program ./bind20 because of the following errors: 0509-150 Dependent module libVMicu20.a(VMicu20.so) could not be loaded. 0509-022 Cannot load module libVMicu20.a(VMicu20.so). 0509-026 System error: A file or director...

My odbc.ini file looks like this....... [PRISMDB2CONNECT] Driver=/ascential/Ascential/DataStage/branded_odbc/lib/VMdb220.so Description=DataDirect 5.00 DB2 Wire Protocol Driver AddStringToCreateTable= AlternateID= Collection=AS/400 DynamicSections=100 GrantAuthid=PUBLIC GrantExecute=1 IpAddress=xxx....

pneuma,
The key for the rules reference table is ColumnNumber and key for the input stream is virtual........which is the column number.......Can u plz give more info on how to go a'bt doing it???

Hello, I'm trying to write a buildop for the following requirement........I have an input stream which has 2 columns ProdID ProdName and I also have a rules reference table which has ColumnNumber Trigger Value suppose the rules reference table has values colNum , Trigger , Value 1 , 2345 , 4567 2 , ...

Hello, I'm trying to read 10 records from a sequential file and write to an oracle table using an ODBC stage since OCI does'nt work for the time being....... Out of the 10 records only 3 of them are unique and when i write it to the table it writes only the unique records.........but i wanted it to ...