Db2/AS400 library connecting via oledb in vb.net
I have been trying to connect a vb.net datalink property to a specific library on a 400. When I fill in the field "Enter the initial catalog to use" I get the message that the catalog is invalid. I have thought it might be a path on the 400, such as QSYS/MyLib, but that errors as well. What am...
I have been trying to connect a vb.net datalink property to a specific library on a 400. When I fill in the field "Enter the initial catalog to use" I get the message that the catalog is invalid. I have thought it might be a path on the 400, such as QSYS/MyLib, but that errors as well. What am...
0 pts.
Using an array in embedded SQL in RPGLE
Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = :odPart(01) C+ and TkQty01 = :odQty(01) C+ and TkPart02 = :odPart(02) C+ and TkQty02 = :odQty(02) There's more to it than that but that should...
Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = :odPart(01) C+ and TkQty01 = :odQty(01) C+ and TkPart02 = :odPart(02) C+ and TkQty02 = :odQty(02) There's more to it than that but that should...
Conversion Project
We are currently working on a project which will at a later date will require alof of data conversion on our existing system to fit the new file structures which are currently been developed. The project is been developed using COBOL on an iSeries, the old and new files will all be physical files....
We are currently working on a project which will at a later date will require alof of data conversion on our existing system to fit the new file structures which are currently been developed. The project is been developed using COBOL on an iSeries, the old and new files will all be physical files....
SQL Errr
Hi I am a novice to SQL and I was hoping someone can tell me where I'm going wrong. I have a small sql statement that keeps giving me an error message. Can any one help please. Thank you in advance. Dawn > UPDATE AMFLIBT.MOROUT SET OPSTC = 40 WHERE (select AMFLIBT.MOROUT.ORDNO,...
Hi I am a novice to SQL and I was hoping someone can tell me where I'm going wrong. I have a small sql statement that keeps giving me an error message. Can any one help please. Thank you in advance. Dawn > UPDATE AMFLIBT.MOROUT SET OPSTC = 40 WHERE (select AMFLIBT.MOROUT.ORDNO,...
can strqmqry be run as remote command
I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ... where ... are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for...
I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ... where ... are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for...
MS SQL Server 2000
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
OPNQRYF's MAPFLD
I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined...
I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined...
SYNON vs COBOL
Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...
Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...
Creating DB2/400 Table Dynamically
Hello, I need to create DB2/400 table from CL or COBOL with some column names which are defined dynamically. How to do this ? Thanks
Hello, I need to create DB2/400 table from CL or COBOL with some column names which are defined dynamically. How to do this ? Thanks
SQL Stored procedure call via ODBC
Trying to call a stored procedure via ODBC, the CA400 ODBC driver uses the SQL (as opposed to SYS) conventions this works fine when procedure is created in QGPL and procedure is called with CALL QGPL.MyNewProcedure(Parm1,Parm2,Parm3) when the procedure is in another library then the call does...
Trying to call a stored procedure via ODBC, the CA400 ODBC driver uses the SQL (as opposed to SYS) conventions this works fine when procedure is created in QGPL and procedure is called with CALL QGPL.MyNewProcedure(Parm1,Parm2,Parm3) when the procedure is in another library then the call does...
Isolation level... Join new JAVA development with old, outdated COBOL code...
Anyone have experience dealing with JAVA and isolation levels? The concern or talk at this shop is how to handle current old COBOL code with new JAVA code with record locks. All Cobol code runs batch mode. Reads daily transaction file to update files. The new world, Java, will be interactive...
Anyone have experience dealing with JAVA and isolation levels? The concern or talk at this shop is how to handle current old COBOL code with new JAVA code with record locks. All Cobol code runs batch mode. Reads daily transaction file to update files. The new world, Java, will be interactive...
Optical storage
I am trying to copy database files from the iSeries to a DVD (optical storage) and would like the files on the DVD created in ASCII text format. Similar to a data transfer from the iSeries, you can specify the file type ASCII text. The database files are actually spooled files that were copied to...
I am trying to copy database files from the iSeries to a DVD (optical storage) and would like the files on the DVD created in ASCII text format. Similar to a data transfer from the iSeries, you can specify the file type ASCII text. The database files are actually spooled files that were copied to...
Tools for DDS to DDL migration
Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...
Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...
Logical file to include only one of many matching records in secondaryu file
I have a one to many relationship between 2 files. Although there are multiple matching records in the secondary file, the fields I am interested in are common. THerefore i only want one of the secondary records to join to the primary record - avaioding duplicate logical records. I know this...
I have a one to many relationship between 2 files. Although there are multiple matching records in the secondary file, the fields I am interested in are common. THerefore i only want one of the secondary records to join to the primary record - avaioding duplicate logical records. I know this...
Connect:Direct CDSND command
Has anybody used this software to send data? We are sending a native file, and were wondering if there was a way to have the file converted to tab delimited on the CDSND command? Or, do we have to tab delimit it to the IFS and CDSND from there ?
Has anybody used this software to send data? We are sending a native file, and were wondering if there was a way to have the file converted to tab delimited on the CDSND command? Or, do we have to tab delimit it to the IFS and CDSND from there ?
Alternate Collating Sequence
I have a logical file keyed by email address and defined with ALTSEQ and dynamic select/omit. My problem is if I perform a READEQ for a specific key value, only records with lower-case keys are returned. I expected the upper-case entries to also be returned. Can anyone shed any light on why this...
I have a logical file keyed by email address and defined with ALTSEQ and dynamic select/omit. My problem is if I perform a READEQ for a specific key value, only records with lower-case keys are returned. I expected the upper-case entries to also be returned. Can anyone shed any light on why this...
The server with this database is no longer responding
I am trying to access a link in a Database on the LNS through the lotus client but it is throwing the error message 'The server with this DB is no longer responding Should notes switch to a replica on other server'. The link is accessible from a other client.I have shutdown the firewall...
I am trying to access a link in a Database on the LNS through the lotus client but it is throwing the error message 'The server with this DB is no longer responding Should notes switch to a replica on other server'. The link is accessible from a other client.I have shutdown the firewall...
CPYFRMIMPF issue
Okay, here's the deal. I've got a tab delimited file that used to load perfectly fine into file using the CPYFRMIMPF command, using the following options; CPYFRMIMPF FROMSTMF('/Directory of file/file.txt') TOFILE(Library/file) MBROPT(*REPLACE) RCDDLM(*CRLF) STRDLM(*NONE) RMVBLANK(*NONE)...
Okay, here's the deal. I've got a tab delimited file that used to load perfectly fine into file using the CPYFRMIMPF command, using the following options; CPYFRMIMPF FROMSTMF('/Directory of file/file.txt') TOFILE(Library/file) MBROPT(*REPLACE) RCDDLM(*CRLF) STRDLM(*NONE) RMVBLANK(*NONE)...
OSDB Connection to AS/400
I am trying to connect the UPS Worldship to our AS/400 (V2r3). The data will download into the 400 file just fine when run separately. I have added a trigger to the physical file so that when a record is written to the physical file, an RPG program is initiated that updated several other files. ...
I am trying to connect the UPS Worldship to our AS/400 (V2r3). The data will download into the 400 file just fine when run separately. I have added a trigger to the physical file so that when a record is written to the physical file, an RPG program is initiated that updated several other files. ...
Data migration strategies-2
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...
