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 [...]

Answer Question   |  November 25, 2006  8:40 PM
DB2 Universal Database, PC/Windows Connectivity

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 = dPart(01) C+ and TkQty01 = dQty(01) C+ and TkPart02 = dPart(02) C+ and TkQty02 = dQty(02) There’s more to it than that but that should give [...]

Answer Question   |  November 30, 2006  11:17 AM
Application development, DB2 Universal Database, Development, RPGLE, SQL

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. I [...]

Answer Question   |  April 19, 2010  6:46 AM
Application development, AS/400, Data analysis, DB2 Universal Database

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, AMFLIBT.MOROUT.OPSEQ, AMFLIBT.MOROUT.OPSTC, amflibt.morout.wkctr, [...]

Answer Question   |  December 18, 2010  10:42 AM
AS/400, DB2 Universal Database

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 editing [...]

Answer Question   |  November 9, 2006  4:52 PM
Application development, AS/400, Backup & recovery, CLP, Data analysis, DB2 Universal Database, PC/Windows Connectivity, Printing

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?

Answer Question   |  November 13, 2006  12:53 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development

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 this way in MAPFLD. I would be [...]

Answer Question   |  November 8, 2006  1:25 PM
Application development, AS/400, Data analysis, Database, DB2, DB2 Universal Database, IBM, IBM Marketing Sound Off, Oracle, RPGLE

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 taking 35 minutes. [...]

Answer Question   |  December 25, 2009  11:27 AM
Application development, AS/400, CLP, DB2 Universal Database, Development, RPG, RPGLE

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

Answer Question   |  November 3, 2006  1:44 AM
DB2 Universal Database

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 not work CALL MYLIB.MyNewProcedure(Parm1,Parm2,Parm3) message is returned SQL0202 [...]

Answer Question   |  November 7, 2006  12:01 PM
DB2 Universal Database, PC/Windows Connectivity

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 update real time code. [...]

Answer Question   |  October 31, 2006  11:52 AM
AS/400, DB2 Universal Database

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 [...]

Answer Question   |  December 25, 2009  9:47 AM
Application development, AS/400, Backup & recovery, DataCenter, DB2 Universal Database

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 [...]

Answer Question   |  October 26, 2006  11:21 AM
Application development, Database, DB2, DB2 Universal Database, Oracle

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 could probably be achieved [...]

Answer Question   |  December 24, 2009  8:03 AM
DB2 Universal Database, RPG, RPGLE

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 ?

Answer Question   |  October 21, 2006  5:43 AM
Application development, AS/400, CLP, DB2 Universal Database, PC/Windows Connectivity

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 might occur [...]

Answer Question   |  December 24, 2009  3:26 PM
AS/400, DB2 Universal Database, RPG

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 also. [...]

Answer Question   |  September 29, 2006  9:51 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DB2 Universal Database, Lotus Domino, Printing, RPG, RPGLE, Security

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) FLDDLM(*TAB) RPLNULLVAL(*FLDDFT) After much research, I’m pretty sure that the issue lies in the changes to the CPYFRMIMPF command in [...]

Answer Question   |  December 17, 2009  3:48 PM
AS/400, DB2 Universal Database, RPG, RPGLE

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. [...]

Answer Question   |  December 17, 2009  10:14 AM
AS/400, DB2 Universal Database

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 files with all the relevant data [...]

Answer Question   |  September 11, 2006  4:02 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management