Cannot rename file or folder in the IFS
Hannonj, It sounds like it is a configuration issue on that PC so at this point if IBM cannot find and duplicate it you might have to go to Microsoft directly for help. Good luck with that one. Lovemyi
View Answer
| September 23, 2010 5:01 PM
IFS, IFS Commands, IFS Folder, iSeries error messages, V5R4
Hannonj, It sounds like it is a configuration issue on that PC so at this point if IBM cannot find and duplicate it you might have to go to Microsoft directly for help. Good luck with that one. Lovemyi
View Answer
| September 23, 2010 5:01 PM
IFS, IFS Commands, IFS Folder, iSeries error messages, V5R4
Change management system for as/400
I’ve worked for years with both Aldon and Turnover. Both are great and fairly easy to learn. Sorry but it’s been many years since I had to price out these products so I have no idea how they stack up. I know that Softlanding was purchased in the past 2 years. <a href=”A href=”http://www.aldon.com/prod/adm/ov”>Aldon</a> <a [...]
View Answer
| September 23, 2010 4:35 PM
AS/400, AS/400 administration, AS/400 Management, Change management, iSeries change management
I’ve worked for years with both Aldon and Turnover. Both are great and fairly easy to learn. Sorry but it’s been many years since I had to price out these products so I have no idea how they stack up. I know that Softlanding was purchased in the past 2 years. <a href=”A href=”http://www.aldon.com/prod/adm/ov”>Aldon</a> <a [...]
View Answer
| September 23, 2010 4:35 PM
AS/400, AS/400 administration, AS/400 Management, Change management, iSeries change management
Reorganization of V5R4 while active
<i>Can someone tell me how to use this?</i> Use it like RGZPFM has always been used. (More later…) <i>Does this come with the operating system or is it a separate module we would need to purchase?</i> It’s been in i5/OS since V5R3. It’s standard. <i>I would appreciate seeing an example of how this works in [...]
View Answer
| September 23, 2010 2:20 AM
CL, CLLE, CLP, RPG, RPG ILE, RPG/400, RPGILE, V5R4
<i>Can someone tell me how to use this?</i> Use it like RGZPFM has always been used. (More later…) <i>Does this come with the operating system or is it a separate module we would need to purchase?</i> It’s been in i5/OS since V5R3. It’s standard. <i>I would appreciate seeing an example of how this works in [...]
View Answer
| September 23, 2010 2:20 AM
CL, CLLE, CLP, RPG, RPG ILE, RPG/400, RPGILE, V5R4
SQL RPGLE – How to override data set data structure at run time
<i>Is there a better way to do this or does the AS400 lack the required flexibility?</i> That’s a tricky question. There are many possibly alternatives between “better way” and “lack the required flexibility”. For dynamic database access, you need to code dynamic access routines. In general, that’s done the same way on AS/400s as it’s [...]
View Answer
| September 23, 2010 12:55 AM
iSeries, RPGLE, SELECT statement, SQL, SQL Select statement problem, SQLRPGLE
<i>Is there a better way to do this or does the AS400 lack the required flexibility?</i> That’s a tricky question. There are many possibly alternatives between “better way” and “lack the required flexibility”. For dynamic database access, you need to code dynamic access routines. In general, that’s done the same way on AS/400s as it’s [...]
View Answer
| September 23, 2010 12:55 AM
iSeries, RPGLE, SELECT statement, SQL, SQL Select statement problem, SQLRPGLE
RPG/400 Trigger Program
Elm021564 - One thing to remember about trigger files; they are expensive! The Trigger program runs in line with the current process. Can the user wait for the process to finish? Trigger files are not field sensitive. You make a change to the FILE and the trigger responds. If you do not care if that [...]
View Answer
| September 23, 2010 12:00 AM
AS/400, AS/400 triggers, iSeries, RPG/400
Elm021564 - One thing to remember about trigger files; they are expensive! The Trigger program runs in line with the current process. Can the user wait for the process to finish? Trigger files are not field sensitive. You make a change to the FILE and the trigger responds. If you do not care if that [...]
View Answer
| September 23, 2010 12:00 AM
AS/400, AS/400 triggers, iSeries, RPG/400
DB2/400 basics
Hi Nutan, For the second part of your question are you looking for the existence of a specific record on a file? If so then you can use SETLL and %EQUAL to check for the existence of the record without doing any input e.g. <pre> SETLL (keyflda : keyfldb : keyfldc) FILEA; IF %Equal(FILEA); …….record [...]
View Answer
| September 22, 2010 1:52 PM
AS/400 DB2, AS/400 Records, DB2/400, INFDS
Hi Nutan, For the second part of your question are you looking for the existence of a specific record on a file? If so then you can use SETLL and %EQUAL to check for the existence of the record without doing any input e.g. <pre> SETLL (keyflda : keyfldb : keyfldc) FILEA; IF %Equal(FILEA); …….record [...]
View Answer
| September 22, 2010 1:52 PM
AS/400 DB2, AS/400 Records, DB2/400, INFDS
OVRDBF help
An OVRDBF used in one job does not have any effect on other jobs. A simple example would be if you have an RPG program that uses FILEA. Here is a CL to use FILEB instead. PGM OVRDBF FILEA FILEB Call RPGPGM DLTOVR FILEA ENDPGM In this case he DLTOVR is not ready needy since [...]
View Answer
| September 21, 2010 6:51 AM
CL Commands, CLLE, Override with Database File, OVRDBF
An OVRDBF used in one job does not have any effect on other jobs. A simple example would be if you have an RPG program that uses FILEA. Here is a CL to use FILEB instead. PGM OVRDBF FILEA FILEB Call RPGPGM DLTOVR FILEA ENDPGM In this case he DLTOVR is not ready needy since [...]
View Answer
| September 21, 2010 6:51 AM
CL Commands, CLLE, Override with Database File, OVRDBF
Testing RPGSQL for the number of records.
I’ve used Tom’s approach and it works well. The following method also works for checking that a record exists without performing the “count”. [CODE ]D RecFound s 1a inz(‘N’) /free reset RecFound; Exec SQL set :RecFound = (select ‘Y’ from sysibm/sysdummy1 where exists (select zip1 from MyZips where zip1 = 15205));</pre>
View Answer
| September 20, 2010 1:38 PM
RPGSQL, SQL, SQL statement, V5R4M0
I’ve used Tom’s approach and it works well. The following method also works for checking that a record exists without performing the “count”. [CODE ]D RecFound s 1a inz(‘N’) /free reset RecFound; Exec SQL set :RecFound = (select ‘Y’ from sysibm/sysdummy1 where exists (select zip1 from MyZips where zip1 = 15205));</pre>
View Answer
| September 20, 2010 1:38 PM
RPGSQL, SQL, SQL statement, V5R4M0
Without using RCVF command can we retrieve AS/400 physical file
Sorry..The question is not very clear. But what I understood from above. You can do this with the combination of CRTPF and OPNQRYF command.
View Answer
| September 18, 2010 10:29 PM
AS/400, AS400 physical file, CLLE, Physical Files, V5R4
Sorry..The question is not very clear. But what I understood from above. You can do this with the combination of CRTPF and OPNQRYF command.
View Answer
| September 18, 2010 10:29 PM
AS/400, AS400 physical file, CLLE, Physical Files, V5R4
Is there a 3rd party tool (or native option) for retrieving data from DB/2 into an Excel spreadsheet complete with pivot tables?
Yes there is and I think our solution is even better as it doesn’t require Excel just any browser. See: http://www.mrc-productivity.com/about/press_PivotTable.html Here’s an example application: http://www.crazybikes.com/mrcjava/servlet/CBB2E.R00180s Feel free to contact me if you have any questions. Sincerely, Sal Stangarone michaels, ross & cole, ltd. 630.916.0662 ext 124
View Answer
| September 17, 2010 3:05 PM
DB2, DB2 Data Transfer, excel, Excel worksheets, Joomla, Pivot tables
Yes there is and I think our solution is even better as it doesn’t require Excel just any browser. See: http://www.mrc-productivity.com/about/press_PivotTable.html Here’s an example application: http://www.crazybikes.com/mrcjava/servlet/CBB2E.R00180s Feel free to contact me if you have any questions. Sincerely, Sal Stangarone michaels, ross & cole, ltd. 630.916.0662 ext 124
View Answer
| September 17, 2010 3:05 PM
DB2, DB2 Data Transfer, excel, Excel worksheets, Joomla, Pivot tables
Purpose of QSQJRN
Just to clarify, this journal and receiver are in library QUSRDIRDB ====================================================== <i>…tell me the purpose of the journal QSQJRN…</i> Journal QSQJRN in library QUSRDIRDB is the journal used by LDAP. <i>I don’t journal any files on my system, so I don’t know why this journal is active.</i> System developers are much more careful with [...]
View Answer
| September 17, 2010 7:22 AM
DataPropagator, Journal objects, QSQJRN, SQL/400
Just to clarify, this journal and receiver are in library QUSRDIRDB ====================================================== <i>…tell me the purpose of the journal QSQJRN…</i> Journal QSQJRN in library QUSRDIRDB is the journal used by LDAP. <i>I don’t journal any files on my system, so I don’t know why this journal is active.</i> System developers are much more careful with [...]
View Answer
| September 17, 2010 7:22 AM
DataPropagator, Journal objects, QSQJRN, SQL/400
Embedded SQL in RPGILE
From the V5R4 SQL Reference:<ul> <li>For a CONNECT for status statement, SQLERRD(3) contains information on the connection status. See “CONNECT (Type 2)” on page 557 for more information.</li><li>For INSERT, UPDATE, REFRESH, and DELETE, shows the number of rows affected.</li><li>For a FETCH statement, SQLERRD(3) contains the number of rows fetched.</li><li>For the PREPARE statement, contains the estimated [...]
View Answer
| September 16, 2010 11:00 PM
RPGILE, SQL Query, SQL/400
From the V5R4 SQL Reference:<ul> <li>For a CONNECT for status statement, SQLERRD(3) contains information on the connection status. See “CONNECT (Type 2)” on page 557 for more information.</li><li>For INSERT, UPDATE, REFRESH, and DELETE, shows the number of rows affected.</li><li>For a FETCH statement, SQLERRD(3) contains the number of rows fetched.</li><li>For the PREPARE statement, contains the estimated [...]
View Answer
| September 16, 2010 11:00 PM
RPGILE, SQL Query, SQL/400
Zipping CSV to AS/400
There are various ways to create usable .ZIP files on AS/400s. One obvious way is to purchase a 3rd-party product or utility that provides a nice, clean user interface into functions on the system or into program code that implements the algorithms used for “zipping” files. I don’t have a list of providers, but I’m [...]
View Answer
| September 16, 2010 10:12 PM
AS/400 CSV, AS/400 FTP, CSV, Zip Files
There are various ways to create usable .ZIP files on AS/400s. One obvious way is to purchase a 3rd-party product or utility that provides a nice, clean user interface into functions on the system or into program code that implements the algorithms used for “zipping” files. I don’t have a list of providers, but I’m [...]
View Answer
| September 16, 2010 10:12 PM
AS/400 CSV, AS/400 FTP, CSV, Zip Files
TAR CVF commands and LTO
What do you mean by “TAR CVF”? Is this just “tar” command with “cvf” switches (that’s all I have been able to google)? If so, tar switch “c” stands for “create”, extraction is made by switch “x”… : tar xf /dev/rt0 (or whatever the tape device is) “v” stands for verbose and is most useful [...]
View Answer
| September 16, 2010 6:06 PM
LTO, LTO tape library, RCVF, Tape Backups, Tape storage, Unix
What do you mean by “TAR CVF”? Is this just “tar” command with “cvf” switches (that’s all I have been able to google)? If so, tar switch “c” stands for “create”, extraction is made by switch “x”… : tar xf /dev/rt0 (or whatever the tape device is) “v” stands for verbose and is most useful [...]
View Answer
| September 16, 2010 6:06 PM
LTO, LTO tape library, RCVF, Tape Backups, Tape storage, Unix
Tape availability in AS/400
Chaster, If you are running BRMS for the backup solution, you need to perform an ADDMLMBRM to add the media to BRMS so that it knows that it is available to that system. Do not initialize the tape if you do not want the data on the tape overwritten until you user it next. Lovemyi
View Answer
| September 16, 2010 5:58 PM
AS/400, Backup, iSeries, iSeries backup, iSeries backup and recovery, Tape Backups
Chaster, If you are running BRMS for the backup solution, you need to perform an ADDMLMBRM to add the media to BRMS so that it knows that it is available to that system. Do not initialize the tape if you do not want the data on the tape overwritten until you user it next. Lovemyi
View Answer
| September 16, 2010 5:58 PM
AS/400, Backup, iSeries, iSeries backup, iSeries backup and recovery, Tape Backups
Capture job data in AS/400
it is a RF Vehicle Mount 5250 Emulation Scanning bar codes as the user moves the items from one bin location to another every once in a while the 5250 will display the X-CLOCK for 20-60 seconds we have a Wireless LAN Controller in place Even added one mor eAccedd Point Chenged RF Units but [...]
View Answer
| September 16, 2010 4:05 AM
AS/400 Active Jobs, AS/400 job logs, AS/400 user sessions, AS400 Job Status
it is a RF Vehicle Mount 5250 Emulation Scanning bar codes as the user moves the items from one bin location to another every once in a while the 5250 will display the X-CLOCK for 20-60 seconds we have a Wireless LAN Controller in place Even added one mor eAccedd Point Chenged RF Units but [...]
View Answer
| September 16, 2010 4:05 AM
AS/400 Active Jobs, AS/400 job logs, AS/400 user sessions, AS400 Job Status
Command line screens
You many want to take a quick look at the Display Command Line Window (QUSCMDLN) API documented <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/topic/apis/quscmdln.htm”>here</a>. Using it you should be able to provide a command key (like F=9) to present a command entry line (with many of the features of the line taken care of for you). Bruce Vining ———————————————————————————————————————– <i>I [...]
View Answer
| September 15, 2010 8:53 PM
Command line, Command Line Processor, Command line tools, QCMDSRC
You many want to take a quick look at the Display Command Line Window (QUSCMDLN) API documented <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/topic/apis/quscmdln.htm”>here</a>. Using it you should be able to provide a command key (like F=9) to present a command entry line (with many of the features of the line taken care of for you). Bruce Vining ———————————————————————————————————————– <i>I [...]
View Answer
| September 15, 2010 8:53 PM
Command line, Command Line Processor, Command line tools, QCMDSRC
Command prompt chatting
you can create a display file that looks like a IM pop-up when sending the message use BRKMSG associate the program with the user profile when a message is received the WINDOW pops up and displays the message when they reply it uses SNDBRKMSG to reply. -sarge
View Answer
| September 15, 2010 2:07 PM
Applications development, Chat applications, Command Prompt screen, Corporate portal applications
you can create a display file that looks like a IM pop-up when sending the message use BRKMSG associate the program with the user profile when a message is received the WINDOW pops up and displays the message when they reply it uses SNDBRKMSG to reply. -sarge
View Answer
| September 15, 2010 2:07 PM
Applications development, Chat applications, Command Prompt screen, Corporate portal applications
Reading (EVAL) a file in RPG
in your file DDS define the file with a UNIQUE key in your RPG /Free Chain (key1 : key2 : Etc) FileName; if Not %Found; Write record; EndIf; /End-Free Or c KEY klist c kfld key1 c kfld key2 c kfld etc c KEY chain file 99 c if *in99 = *On c write record [...]
View Answer
| September 15, 2010 2:02 PM
AS/400, CL programming, EVAL function, RPG
in your file DDS define the file with a UNIQUE key in your RPG /Free Chain (key1 : key2 : Etc) FileName; if Not %Found; Write record; EndIf; /End-Free Or c KEY klist c kfld key1 c kfld key2 c kfld etc c KEY chain file 99 c if *in99 = *On c write record [...]
View Answer
| September 15, 2010 2:02 PM
AS/400, CL programming, EVAL function, RPG
