not a valid Query Management variable.
Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement...
Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement...
5 pts.
Best way to retrieve values, SQL or Queries and how?
Hello everybody, my problem is, in a iseries i have ia file and in this file exist one field with 10000 lenght (character) and i want retrieve a value like ( 60F: ) but i don´t know in what position, after i find this value i need the follow values. ex: this is a part of one record {4: ...
Hello everybody, my problem is, in a iseries i have ia file and in this file exist one field with 10000 lenght (character) and i want retrieve a value like ( 60F: ) but i don´t know in what position, after i find this value i need the follow values. ex: this is a part of one record {4: ...
Connection to Iseries for multiple users V5R4
Have shared computer and need to make connection to iseries that works for each user that logs onto the system without having to make same connection manually for each user. Software/Hardware used: Client Express V5R4
Have shared computer and need to make connection to iseries that works for each user that logs onto the system without having to make same connection manually for each user. Software/Hardware used: Client Express V5R4
FOLDER DUPLICATION
SAP adds many TXT files to a folder in IFS, I need to replicate or duplicate this TXT files in a Windows Server folder automatically or share the iSeries folder with the Windows Server users. How can I do this? Thanks Software/Hardware used: i5 OS V5R4
SAP adds many TXT files to a folder in IFS, I need to replicate or duplicate this TXT files in a Windows Server folder automatically or share the iSeries folder with the Windows Server users. How can I do this? Thanks Software/Hardware used: i5 OS V5R4
Spooled files not saved after printing when migrating to V5R4
We migrated from V5R3 to V5R4. A user tells us that spooled files that used to change to SAV after printing are 'disappearing'. What could have changed?
We migrated from V5R3 to V5R4. A user tells us that spooled files that used to change to SAV after printing are 'disappearing'. What could have changed?
Convert to PDF
Please guide on how do we use Convert to PDF from i series navigator. We are on V5R4. Need the steps to be followed in order to convert a spool file to a pdf. What needs to be done in order to save it to a location on the PC.
Please guide on how do we use Convert to PDF from i series navigator. We are on V5R4. Need the steps to be followed in order to convert a spool file to a pdf. What needs to be done in order to save it to a location on the PC.
what is the diffrence beetween v5r3 and v5r4 ?
what is the diffrence beetween v5r3 and v5r4 ? Could some one list it down for me? Software/Hardware used: AS400 - OS400
what is the diffrence beetween v5r3 and v5r4 ? Could some one list it down for me? Software/Hardware used: AS400 - OS400
Operator Action Required on Device XX
I have an HP 4015dtn setup as a *LAN printer on our iSeries. Device Class - *LAN Device Type - 3812 Device Model - 1 MFRTYPMDL - *HP 4 and *HP4000 SYSDRVPGM - HPPJLDRV We continually get the Operator Action Required on Device XX (C R) (xx being the name of our dev printer). We have to answer this...
I have an HP 4015dtn setup as a *LAN printer on our iSeries. Device Class - *LAN Device Type - 3812 Device Model - 1 MFRTYPMDL - *HP 4 and *HP4000 SYSDRVPGM - HPPJLDRV We continually get the Operator Action Required on Device XX (C R) (xx being the name of our dev printer). We have to answer this...
Defining a sort variable (ORDER by) in RPG SQL
I have a file that I would like to sort on a specific column that a user would choose. I sort the file by an imbedded SQL statement: ORDER by PRDNO. Works fine. If I try and make it a variable (ORDER by :Sort_Seq), the statement is ignored. Is there a way to make the ORDER by a variable in RPG...
I have a file that I would like to sort on a specific column that a user would choose. I sort the file by an imbedded SQL statement: ORDER by PRDNO. Works fine. If I try and make it a variable (ORDER by :Sort_Seq), the statement is ignored. Is there a way to make the ORDER by a variable in RPG...
IFS - security, Using mkdir() and I want new directory to inherit authorization list from it's parent directory
iseries rpgle pgm Using mkdir() and I want new directory to inherit authorization list from it's parent directory. i am not clear on what mode to set. Can this be accomplished using mkdir() or should I be usinf another command? Thanks in advance Debbie Software/Hardware used: iseries v5r4
iseries rpgle pgm Using mkdir() and I want new directory to inherit authorization list from it's parent directory. i am not clear on what mode to set. Can this be accomplished using mkdir() or should I be usinf another command? Thanks in advance Debbie Software/Hardware used: iseries v5r4
How to clean up AS/400 receivers when those are in online status?
Hello All, The situation – There was a user's job which was gone into the loop and caused in huge number of journal receivers which was gone up to more than 2045 (Approx 3000). We have killed the job which was causing this and the situation was under control.Nit400 Software/Hardware used: V5R4
Hello All, The situation – There was a user's job which was gone into the loop and caused in huge number of journal receivers which was gone up to more than 2045 (Approx 3000). We have killed the job which was causing this and the situation was under control.Nit400 Software/Hardware used: V5R4
Using MS Acess SQL Passthrough To AS400 to find wholes in number sequence between to files
Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I know...
Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I know...
Access to 'object in use' attribute of IFS object from QSYS RPGLE
If you open a document which is stored in the IFS with OpenOffice, examining the object with Navigator allows you to see the 'in Use' property - it says that there is 1 Netserver reference. Examining DSPLNK for the same object shows no such 'in use' attribute. How do I get to that attribute in...
If you open a document which is stored in the IFS with OpenOffice, examining the object with Navigator allows you to see the 'in Use' property - it says that there is 1 Netserver reference. Examining DSPLNK for the same object shows no such 'in use' attribute. How do I get to that attribute in...
Jobs goes into Message Wait after reaching End Of File.
I am using the below programs to Delete Temporary Files from Specific Libraries on monthly basis after taking a Entire System Backup. [strong]The File and Library Names are stored in a Output File called MNTHDELE in QGPL and the Column Names are &ODLBNM for File Name and &ODOBNM for Library...
I am using the below programs to Delete Temporary Files from Specific Libraries on monthly basis after taking a Entire System Backup. [strong]The File and Library Names are stored in a Output File called MNTHDELE in QGPL and the Column Names are &ODLBNM for File Name and &ODOBNM for Library...
DSP02 on HMC
On the HMC of our 9408-M25 V5R4, the 5250 display is DSP02. In the past, I'm almost positive that it was DSP01. Two questions: 1) will it being DSP02 (running in QCTL) cause any problems for a BRMS system backup (restricted state)? 2) is there a way to get this back to DSP01?
On the HMC of our 9408-M25 V5R4, the 5250 display is DSP02. In the past, I'm almost positive that it was DSP01. Two questions: 1) will it being DSP02 (running in QCTL) cause any problems for a BRMS system backup (restricted state)? 2) is there a way to get this back to DSP01?
AS400 File to MS Access by SQL Passthrough Query
I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM...
I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM...
AS/400 User Profile Disabling
Two weekends ago I upgraded our i520 from OS V5R3M0 to V5R4M0 and ever since we have had problems with user profiles becoming disabled. These are not because of incorrect password either, as many users are ones who use the system daily and have had no previouse issues with passwords.
Two weekends ago I upgraded our i520 from OS V5R3M0 to V5R4M0 and ever since we have had problems with user profiles becoming disabled. These are not because of incorrect password either, as many users are ones who use the system daily and have had no previouse issues with passwords.
Disappearing i5 spoolfile
I have a spoolfile I suspect a user is moving to a printer, without saving first. Other users are thinking is not generating. It only happens to Friday nights report. I actually caught it on 7/31/09 but didn't think to save it then. I didn't move it so I could see what happen on Monday. Sure...
I have a spoolfile I suspect a user is moving to a printer, without saving first. Other users are thinking is not generating. It only happens to Friday nights report. I actually caught it on 7/31/09 but didn't think to save it then. I didn't move it so I could see what happen on Monday. Sure...
HMC Details
Dear All As we know we r using AS400 520 Server with OS V5r4mo .We wnt to Use Latest HMC ,which hmc will Best to use ,as we can install hmc application on windows pc, if yes than what will be he configuartion of wondows pc or its require additional hardware to do so ............,or we can get...
Dear All As we know we r using AS400 520 Server with OS V5r4mo .We wnt to Use Latest HMC ,which hmc will Best to use ,as we can install hmc application on windows pc, if yes than what will be he configuartion of wondows pc or its require additional hardware to do so ............,or we can get...
