Methods used to maintain the access path of a file
Sarang wrote in with this question recently: "Can someone please name and define the three methods used to maintain the access path of a file?" Do you know the methods? -- Debra Tart, associate editor, Search400.com
Sarang wrote in with this question recently: "Can someone please name and define the three methods used to maintain the access path of a file?" Do you know the methods? -- Debra Tart, associate editor, Search400.com
0 pts.
Advice needed to move from DB2/400 flat-file system to Oracle
Koteswararao wrote in with this question recently: "We are planning to move from a DB2/400 flat-file system to Oracle. We do not have any relations in DB2/400. I want to extract the metamodel(total DDL scripts) from DB2/400 and go to datamodeling. Initially I thought Oracle Migration Workbench...
Koteswararao wrote in with this question recently: "We are planning to move from a DB2/400 flat-file system to Oracle. We do not have any relations in DB2/400. I want to extract the metamodel(total DDL scripts) from DB2/400 and go to datamodeling. Initially I thought Oracle Migration Workbench...
Using SQLRPG on a DDM File
Hi, I need to access a DDM file via SQLRPG -since SQL does not directly support DDM -can it be done by first using OVRDBF on the DDM file to override it to a local file and then use SQLRPG ? Help would be much appreciated for a project I am currently working on. Thank you! Ruwan
Hi, I need to access a DDM file via SQLRPG -since SQL does not directly support DDM -can it be done by first using OVRDBF on the DDM file to override it to a local file and then use SQLRPG ? Help would be much appreciated for a project I am currently working on. Thank you! Ruwan
Updating a VSAM file
Tim wrote in with this question recently: "I need to update a VSAM file on a mainframe connected to an AS/400 -- via TCP/IP. Ideally, I would like to add/delete/update a record on the AS/400 and have the database issue a call to a CICS program on the mainframe, pass data to the CICS program and...
Tim wrote in with this question recently: "I need to update a VSAM file on a mainframe connected to an AS/400 -- via TCP/IP. Ideally, I would like to add/delete/update a record on the AS/400 and have the database issue a call to a CICS program on the mainframe, pass data to the CICS program and...
Looking for a utility to list all used queries and files
Pat wrote in with this question recently: "I need a utility to list all queries and files used, date used, etc. I am on V5R1." Can you point him in the correct direction? -- Debra Tart , associate editor, Search400.com
Pat wrote in with this question recently: "I need a utility to list all queries and files used, date used, etc. I am on V5R1." Can you point him in the correct direction? -- Debra Tart , associate editor, Search400.com
Anyone ever use the SNDRPY command in CL?
I am using the CHGPF command to change a file. I know it will result in data loss, and I will get a messaage that I must reply "I" to ignore and then it will change the file. The file is used all day long and I would like to have a CL program change it after hours. I found the SNDRPY command...
I am using the CHGPF command to change a file. I know it will result in data loss, and I will get a messaage that I must reply "I" to ignore and then it will change the file. The file is used all day long and I would like to have a CL program change it after hours. I found the SNDRPY command...
SET verb in COBOL
Hi The SET verb in COBOL set the value of a particular variable to a specified value. Now say I decalred a variable as 05 WS-SWITCH PIC X(01). 88 VALID-VALUES VALUE 'A', 'B', 'C'. 88 NOT-VALID-VALUES VALUE 'D', 'E', 'F'. If I want to set the value...
Hi The SET verb in COBOL set the value of a particular variable to a specified value. Now say I decalred a variable as 05 WS-SWITCH PIC X(01). 88 VALID-VALUES VALUE 'A', 'B', 'C'. 88 NOT-VALID-VALUES VALUE 'D', 'E', 'F'. If I want to set the value...
Data Integration
We are in the beginning stages of integrating data between a PC based inventory system and the iSeries. Specifically we will be downloading and uploading data between the two systems automatically. We have had success using ODBC. We also need to be able to call an RPG program from the PC based...
We are in the beginning stages of integrating data between a PC based inventory system and the iSeries. Specifically we will be downloading and uploading data between the two systems automatically. We have had success using ODBC. We also need to be able to call an RPG program from the PC based...
What is correct syntax for SQL for Maxrecords in OS400/DB2?
What is correct syntax for SQL for Maxrecords in OS400/DB2? We have a process automatically generating SQL code. However, our iSeries doesn't recognise the code it generates for maxrecords. Here are the examples of what I mean. The DB2 database seems happy with SELECT I1PHON,I1ACC,I1ACC1, FROM...
What is correct syntax for SQL for Maxrecords in OS400/DB2? We have a process automatically generating SQL code. However, our iSeries doesn't recognise the code it generates for maxrecords. Here are the examples of what I mean. The DB2 database seems happy with SELECT I1PHON,I1ACC,I1ACC1, FROM...
DB2 Joins
Can someone explain the order this join specification will be performed in? RSINDIP LEFT OUTER JOIN RSINDPP ON RSINDIP.INICID=RSINDPP.IPICID LEFT OUTER JOIN MKEMLAP ON RSINDIP.INCID=MKEMLAP.ELEMIC LEFT OUTER JOIN MKIPRMP ON RSINDIP.INICID=MKIPRMP.IKICID ...
Can someone explain the order this join specification will be performed in? RSINDIP LEFT OUTER JOIN RSINDPP ON RSINDIP.INICID=RSINDPP.IPICID LEFT OUTER JOIN MKEMLAP ON RSINDIP.INCID=MKEMLAP.ELEMIC LEFT OUTER JOIN MKIPRMP ON RSINDIP.INICID=MKIPRMP.IKICID ...
How to operating with Multiple Member PF in RPG ?
I have a multiple member physical file and I want to operate(read/update/delete) with specific member in RPG. The member name for that PF need to be set at runtime depending upon from which program this rpg program is called. I am writing the sample code that I was trying, but it ends up with...
I have a multiple member physical file and I want to operate(read/update/delete) with specific member in RPG. The member name for that PF need to be set at runtime depending upon from which program this rpg program is called. I am writing the sample code that I was trying, but it ends up with...
Printek printer using tcpip
What does the spool file need to look like to print a barcode on a printek 4305 se printer? I cant figure out how to send the hex command to the printer so it understands that it is a command not just text.
What does the spool file need to look like to print a barcode on a printek 4305 se printer? I cant figure out how to send the hex command to the printer so it understands that it is a command not just text.
rpg
We just upgraded to an iSeries box with 5.3. We were running 4.6. My RPG programs function properly until I recompile the program. Then I get an compile error 7073 regarding the length of a key field not equal. The compile shows BIN2 (and sometimes multiples) after the other key fields and I can't...
We just upgraded to an iSeries box with 5.3. We were running 4.6. My RPG programs function properly until I recompile the program. Then I get an compile error 7073 regarding the length of a key field not equal. The compile shows BIN2 (and sometimes multiples) after the other key fields and I can't...
Help running interactive SQL statement
This user recently upgraded from V4R5 to V5R2, and now they're having difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and...
This user recently upgraded from V4R5 to V5R2, and now they're having difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and...
export sql server to iseries files
when I attempt to export a file most vchar and char fields default to datalink type via odbc. The iseries does not like the datalink type as then it can't find the link. When I try to force the vchar field it creates the file but then on the copy tells me the field is not found Any...
when I attempt to export a file most vchar and char fields default to datalink type via odbc. The iseries does not like the datalink type as then it can't find the link. When I try to force the vchar field it creates the file but then on the copy tells me the field is not found Any...
Connecting to the Database
I am trying to connect my project in Visual C++ 6.0 to the database in Microsoft Access 2003 using DAO but am receiving an error message stating that 'unrecognised database format', how can I do it then?
I am trying to connect my project in Visual C++ 6.0 to the database in Microsoft Access 2003 using DAO but am receiving an error message stating that 'unrecognised database format', how can I do it then?
QsnBeep
Does anybody know if I can use the QsnBeep (QSNAPI) several times in a RPG-ILE but with different 'beeps'. For example, there are 2 possible errors in an interactive program, can I generate 2 different error-sounds ? Or does it ALWAYS uses the PC5250 host bell ? Although I think it is another story...
Does anybody know if I can use the QsnBeep (QSNAPI) several times in a RPG-ILE but with different 'beeps'. For example, there are 2 possible errors in an interactive program, can I generate 2 different error-sounds ? Or does it ALWAYS uses the PC5250 host bell ? Although I think it is another story...
making CHGOBJOWN faster
Is there a way to make a command like CHGOBJOWN run faster. Rather than waiting to get an exclusive lock on the object I would rather see the command try once and move on. I still need to capture the fact that the change failed, I just want it to fail quicker if it is going to fail.
Is there a way to make a command like CHGOBJOWN run faster. Rather than waiting to get an exclusive lock on the object I would rather see the command try once and move on. I still need to capture the fact that the change failed, I just want it to fail quicker if it is going to fail.
Access SQL Server 2003 database from ISeries
Hello everyone, I have searched the web for SQL Server/ISeries connectivity and have come across some interesting options: java, JDBC etc. But they have not been very clear. I understand that it is not a simple task, but has anyone successfully accessed an SQL Server database from ISeries using...
Hello everyone, I have searched the web for SQL Server/ISeries connectivity and have come across some interesting options: java, JDBC etc. But they have not been very clear. I understand that it is not a simple task, but has anyone successfully accessed an SQL Server database from ISeries using...
How do I retrieve the JOB/USER/NBR for a spoolfile generated by a GUI program?
I have a GUI program which HAS to run interactively that generates a spoolfile. The HTTP job (Which is what I correctly retrieved using RTVJOBA & QUSRJOBI)is: Job: VOI User: QTMHHTTP Number: 303484 But the job that my spoolfile has is: Job: QPRTJOB User: ...
I have a GUI program which HAS to run interactively that generates a spoolfile. The HTTP job (Which is what I correctly retrieved using RTVJOBA & QUSRJOBI)is: Job: VOI User: QTMHHTTP Number: 303484 But the job that my spoolfile has is: Job: QPRTJOB User: ...
