Need to display a PDF on i5
Assuming that you stored the .pdf file on the IFS (using OVRPRTF parameter TOSTMF), this is how I have solved a similar task: First of all make sure that PCO is active. Use STRPCO and MONMSG(IWS4010). Then build a variable containing path and filename of the .pdf. Fx CGHVAR &STRING to ‘d:/[mypath]/[mydocname].pdf’ . Assign a [...]
View Answer
| February 16, 2011 4:24 PM
i5, iSeries printing, OVRPRTF, PDF
Assuming that you stored the .pdf file on the IFS (using OVRPRTF parameter TOSTMF), this is how I have solved a similar task: First of all make sure that PCO is active. Use STRPCO and MONMSG(IWS4010). Then build a variable containing path and filename of the .pdf. Fx CGHVAR &STRING to ‘d:/[mypath]/[mydocname].pdf’ . Assign a [...]
View Answer
| February 16, 2011 4:24 PM
i5, iSeries printing, OVRPRTF, PDF
I have more than 1000 objects in one library need to segregate type wise.
First get a list of all objects in the library. DSPOBJD OBJ(?Yourlib/*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/YOURFILE) This will create a file with files that you can use to do the moves for you. Once you determine some logic to make the decision as to where to move what, Write a CL program to read this file [...]
View Answer
| February 16, 2011 4:01 PM
AS/400 Library, AS/400 objects, CL Program
First get a list of all objects in the library. DSPOBJD OBJ(?Yourlib/*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/YOURFILE) This will create a file with files that you can use to do the moves for you. Once you determine some logic to make the decision as to where to move what, Write a CL program to read this file [...]
View Answer
| February 16, 2011 4:01 PM
AS/400 Library, AS/400 objects, CL Program
Need a Sample of Logical Network Design
Please go to this link : http://www.edrawsoft.com/Network-Diagram-Examples.php OR http://people.uwec.edu/hiltonts/101/CBAsample/projectsample.htm —————————— You mentioned “I need a sample of logical network design including the access layer, distribution layer and core layer for the following issues ” and Points A and C are more server/ software based issues. Point B is relatively easy – a good (wireless or [...]
View Answer
| February 16, 2011 3:19 PM
Client Access, Logical Network Design, Networking, WLAN, WLAN access points
Please go to this link : http://www.edrawsoft.com/Network-Diagram-Examples.php OR http://people.uwec.edu/hiltonts/101/CBAsample/projectsample.htm —————————— You mentioned “I need a sample of logical network design including the access layer, distribution layer and core layer for the following issues ” and Points A and C are more server/ software based issues. Point B is relatively easy – a good (wireless or [...]
View Answer
| February 16, 2011 3:19 PM
Client Access, Logical Network Design, Networking, WLAN, WLAN access points
TCP/IP limits on routers/switches
Your router and switches just assist in getting users conencted to your LAN/WAN and have no bearing on how many concurrent Terminal Services / telnet clients your server can support – thats a server config issue…
View Answer
| February 16, 2011 2:23 PM
AS/400, Routers, Switches, TCP/IP CONNECTION, TCP/IP terminal limits
Your router and switches just assist in getting users conencted to your LAN/WAN and have no bearing on how many concurrent Terminal Services / telnet clients your server can support – thats a server config issue…
View Answer
| February 16, 2011 2:23 PM
AS/400, Routers, Switches, TCP/IP CONNECTION, TCP/IP terminal limits
Windows 7 and iSeries for Windows
Try booting into Safe Mode (press F8 ) & see if u get the same problem. If not, then it is likely a software related problem. Here use “msconfig” to disable all startup programs and turn them on one by one until the problem returns. Also check power setting to see if this could be [...]
View Answer
| February 16, 2011 8:57 AM
iSeries, Windows 7, Windows 7 support
Try booting into Safe Mode (press F8 ) & see if u get the same problem. If not, then it is likely a software related problem. Here use “msconfig” to disable all startup programs and turn them on one by one until the problem returns. Also check power setting to see if this could be [...]
View Answer
| February 16, 2011 8:57 AM
iSeries, Windows 7, Windows 7 support
Subsystem AS/400 user library list not set properly
I would look into the joblog for one of the following: 1. Job tried to add a library that does not exist anymore. 2. User not authorized to a library. 3. Library is locked and not available. 4. A library is specified twice in the library list. If you do not see one of those [...]
View Answer
| February 15, 2011 7:50 PM
AS/400 administration, AS/400 error messages, AS/400 subsystems, V5R3
I would look into the joblog for one of the following: 1. Job tried to add a library that does not exist anymore. 2. User not authorized to a library. 3. Library is locked and not available. 4. A library is specified twice in the library list. If you do not see one of those [...]
View Answer
| February 15, 2011 7:50 PM
AS/400 administration, AS/400 error messages, AS/400 subsystems, V5R3
Converting AS/400 calender date to julian date
(Isolate the year * 1000) + (number of days from Jan 1 of said year)
View Answer
| February 15, 2011 6:49 PM
AS/400 command functions, AS/400 commands, AS/400 date format, Date conversion
(Isolate the year * 1000) + (number of days from Jan 1 of said year)
View Answer
| February 15, 2011 6:49 PM
AS/400 command functions, AS/400 commands, AS/400 date format, Date conversion
D Spec on DS in AS/400
The DS defines a Data Structure. The S defines a single field. A Data Structure is a group of fields. Here is a sample: * d inRecordDS ds d inData 94a d inkey 39a d recType 1a overlay(inData:1) * In my code, I can reference inRecordDS which will be 133 characters long Or I can [...]
View Answer
| February 15, 2011 5:47 PM
AS/400, AS/400 database administration, AS400 Data Definitions
The DS defines a Data Structure. The S defines a single field. A Data Structure is a group of fields. Here is a sample: * d inRecordDS ds d inData 94a d inkey 39a d recType 1a overlay(inData:1) * In my code, I can reference inRecordDS which will be 133 characters long Or I can [...]
View Answer
| February 15, 2011 5:47 PM
AS/400, AS/400 database administration, AS400 Data Definitions
Chain in RPG IV
A chain operation is used to get a specific record from the database. It is mostly used with the file’s primary key. This operation blocks the record, so you can modify it later. If I need to get some records, I use SETLL, SETGT, READ and READP operations, but if I need to get a [...]
View Answer
| February 15, 2011 4:47 PM
AS400 Data Definitions, CHAIN, RPG IV
A chain operation is used to get a specific record from the database. It is mostly used with the file’s primary key. This operation blocks the record, so you can modify it later. If I need to get some records, I use SETLL, SETGT, READ and READP operations, but if I need to get a [...]
View Answer
| February 15, 2011 4:47 PM
AS400 Data Definitions, CHAIN, RPG IV
Free IT Book: AAA Identity Management Security
Hi, Just posted my answer to <b>Bandwidth & prerequisites for VMware View</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/vmware-view/”>here</a>. An answer to <b>Upgrade Exchange 2007 from 2003 (downgrade license of 2007)</b> posted <a href=”http://itknowledgeexchange.techtarget.com/itanswers/upgrade-exchange-2007-from-2003-downgrade-license-of-2007/”>here</a>.
View Answer
| February 15, 2011 4:47 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Hi, Just posted my answer to <b>Bandwidth & prerequisites for VMware View</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/vmware-view/”>here</a>. An answer to <b>Upgrade Exchange 2007 from 2003 (downgrade license of 2007)</b> posted <a href=”http://itknowledgeexchange.techtarget.com/itanswers/upgrade-exchange-2007-from-2003-downgrade-license-of-2007/”>here</a>.
View Answer
| February 15, 2011 4:47 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
AS/400 via Access, update query
Hi, look at this thread right here: <a href=”http://itknowledgeexchange.techtarget.com/itanswers/how-to-avoid-sql7008-error-from-db2-on-iseries/”>SQL7008</a> Regards.
View Answer
| February 15, 2011 3:47 PM
Access query, AS/400, AS/400 database, AS/400 Query
Hi, look at this thread right here: <a href=”http://itknowledgeexchange.techtarget.com/itanswers/how-to-avoid-sql7008-error-from-db2-on-iseries/”>SQL7008</a> Regards.
View Answer
| February 15, 2011 3:47 PM
Access query, AS/400, AS/400 database, AS/400 Query
Avoid Hard Coding in AS/400 RPGLE
OK, THis is what is sounds like what you wnat to do. You do not want to hard code anything, and also want to produce and online message. First you create the tables to store the data you want (either the way already described or some other way). Next once the files are populated you [...]
View Answer
| February 15, 2011 3:18 PM
AS400 RPGLE, Grouping, RPGLE
OK, THis is what is sounds like what you wnat to do. You do not want to hard code anything, and also want to produce and online message. First you create the tables to store the data you want (either the way already described or some other way). Next once the files are populated you [...]
View Answer
| February 15, 2011 3:18 PM
AS400 RPGLE, Grouping, RPGLE
CPF8361 Error after V6R1 Upgrade
We saw this error ater a new release where SQL defaulted to commit *YES Try the SQL SET OPTION statement to control COMMITT There might be a meaningful message in the job log above the error. Good Luck
View Answer
| February 15, 2011 2:19 AM
iSeries Upgrades, RPG, SQL, V6R1
We saw this error ater a new release where SQL defaulted to commit *YES Try the SQL SET OPTION statement to control COMMITT There might be a meaningful message in the job log above the error. Good Luck
View Answer
| February 15, 2011 2:19 AM
iSeries Upgrades, RPG, SQL, V6R1
Journal Receiver Deletion and CPF7024
Looks like it could be a couple of issue, Commitment Control or File still in open status. Here is a link that completely expalins the possible problems and the solution. This should take care of it for you. Journaling – Problem Determination for CPF7024 http://www-01.ibm.com/support/docview.wss?uid=nas191dd74dc0e68bd988625685800569038
View Answer
| February 14, 2011 9:53 PM
AS/400 journaling, Journal Receivers
Looks like it could be a couple of issue, Commitment Control or File still in open status. Here is a link that completely expalins the possible problems and the solution. This should take care of it for you. Journaling – Problem Determination for CPF7024 http://www-01.ibm.com/support/docview.wss?uid=nas191dd74dc0e68bd988625685800569038
View Answer
| February 14, 2011 9:53 PM
AS/400 journaling, Journal Receivers
Modify SNDDST or equivalent so emails from iSeries are in RTF or HTML
If you are looking for something free, you could probably do this with something like MMAIL, which is what I used when I found myself in a similar situation. Now that the request for reports being emailed from the i5 has grown to include excel, PDF and text, I went with MAILTOOL from BVStools. Definitely [...]
View Answer
| February 14, 2011 8:27 PM
iSeries, iSeries email, RTF, SNDDST
If you are looking for something free, you could probably do this with something like MMAIL, which is what I used when I found myself in a similar situation. Now that the request for reports being emailed from the i5 has grown to include excel, PDF and text, I went with MAILTOOL from BVStools. Definitely [...]
View Answer
| February 14, 2011 8:27 PM
iSeries, iSeries email, RTF, SNDDST
Contest Bounties: Last chance to win an iPad!
tweeted about IT Knowledge Exchange via twitter..
View Answer
| February 12, 2011 1:03 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
tweeted about IT Knowledge Exchange via twitter..
View Answer
| February 12, 2011 1:03 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Open IT Forum: Security Worst-Cases
We had an IT exec who also wanted to write code, especially SQL. He would take nice compact stored procedures and turn them into a nightmare. Not only did he rewrite 75 % of the stored procedures, he bypassed our content control system doing it so none of it was documented. He had procedures that [...]
View Answer
| February 11, 2011 6:18 PM
AS/400, Channel, CIO, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
We had an IT exec who also wanted to write code, especially SQL. He would take nice compact stored procedures and turn them into a nightmare. Not only did he rewrite 75 % of the stored procedures, he bypassed our content control system doing it so none of it was documented. He had procedures that [...]
View Answer
| February 11, 2011 6:18 PM
AS/400, Channel, CIO, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
File and Fields in RPG400
well, if your database file of files contains the field’s attributes like starting locations, lengths, decimal positions, and the data types of the field, you could define a long flat file as usropn, and by using the extfile keyword open the specified file, read it in as a long character field, and use %subst, %dec, [...]
View Answer
| February 11, 2011 3:33 PM
AS400 RPGLE, RPG/400, RPG/400 field validation
well, if your database file of files contains the field’s attributes like starting locations, lengths, decimal positions, and the data types of the field, you could define a long flat file as usropn, and by using the extfile keyword open the specified file, read it in as a long character field, and use %subst, %dec, [...]
View Answer
| February 11, 2011 3:33 PM
AS400 RPGLE, RPG/400, RPG/400 field validation
PM400 screen to print
You can do a WRKOBJPDM LIB(QMPGDATA) OBJ(*ALL) page down until you come to the PF, find the one you want to work with, take option 12, and and select the member. You can also use SQL or QRY to list what you need to show on the report.
View Answer
| February 11, 2011 2:45 PM
CSV, iSeries, iSeries printing, PM/400, V5R4M0
You can do a WRKOBJPDM LIB(QMPGDATA) OBJ(*ALL) page down until you come to the PF, find the one you want to work with, take option 12, and and select the member. You can also use SQL or QRY to list what you need to show on the report.
View Answer
| February 11, 2011 2:45 PM
CSV, iSeries, iSeries printing, PM/400, V5R4M0
Data transfer from Access 2007 to Excel 2007 stops at 65,xxx rows
the short answer is “no, you cannot make this a million row spreadsheets.” you have to make multiple spreadsheets in the book. in this way, you can use a counter to find the magic number of 65,536 records and then start a new spreadsheet each time the counter hits this number. then in the last [...]
View Answer
| February 11, 2011 9:13 AM
Access 2007, Data transfer, Data Transfer Function, Excel 2007, Excel Database
the short answer is “no, you cannot make this a million row spreadsheets.” you have to make multiple spreadsheets in the book. in this way, you can use a counter to find the magic number of 65,536 records and then start a new spreadsheet each time the counter hits this number. then in the last [...]
View Answer
| February 11, 2011 9:13 AM
Access 2007, Data transfer, Data Transfer Function, Excel 2007, Excel Database
