AS/400 query
Just a thought. In cases list this, I have moved away from providing users with reports that they ned up wanting to manipulate. Consider just creating a .csv file. Users can pull that into Excel and play until long after you have gone home for the day The can SUM, AVG, Filter, Hide, etc. I [...]
View Answer
| June 14, 2011 7:12 PM
AS/400, AS/400 Query, AS/400 Reports, Query/400
Just a thought. In cases list this, I have moved away from providing users with reports that they ned up wanting to manipulate. Consider just creating a .csv file. Users can pull that into Excel and play until long after you have gone home for the day The can SUM, AVG, Filter, Hide, etc. I [...]
View Answer
| June 14, 2011 7:12 PM
AS/400, AS/400 Query, AS/400 Reports, Query/400
Open IT Forum: What tech blogs and Twitter feeds do you follow?
Oracle_Edu
View Answer
| June 14, 2011 1:54 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Blogs, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Oracle_Edu
View Answer
| June 14, 2011 1:54 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Blogs, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
How to trap the errors with out using monmsg?
Can you explain why you would want to do this.
View Answer
| June 14, 2011 1:30 PM
AS/400 error messages, CL Errors, CL Program, MONMSG
Can you explain why you would want to do this.
View Answer
| June 14, 2011 1:30 PM
AS/400 error messages, CL Errors, CL Program, MONMSG
Commitment control in SQLRPGLE
Since your using SQLRPGLE Commitment control of the Sql processes is based on the Sql commit value. You can set this value by issuing the SqL command set option commit xxx with xxx being one of these values *CHG *NONE *CS *ALL *RR Of couse the files must be journaled The sql command COMMIT or [...]
View Answer
| June 10, 2011 10:36 AM
AS/400, iSeries Commands, iSeries commitment control, RPG Commit, SQLRPGLE
Since your using SQLRPGLE Commitment control of the Sql processes is based on the Sql commit value. You can set this value by issuing the SqL command set option commit xxx with xxx being one of these values *CHG *NONE *CS *ALL *RR Of couse the files must be journaled The sql command COMMIT or [...]
View Answer
| June 10, 2011 10:36 AM
AS/400, iSeries Commands, iSeries commitment control, RPG Commit, SQLRPGLE
AS/400 tab text delimited format of physical file
Can you also state which ‘utility tool’ you are using for the download. We’ll all assume that you are refering to Client Acess transfers, but there are others.
View Answer
| June 10, 2011 9:30 AM
AS/400, AS/400 Database File, CLP, CPYTOIMPF, Database Files, DBF file
Can you also state which ‘utility tool’ you are using for the download. We’ll all assume that you are refering to Client Acess transfers, but there are others.
View Answer
| June 10, 2011 9:30 AM
AS/400, AS/400 Database File, CLP, CPYTOIMPF, Database Files, DBF file
Embedded SQL using SUM or some other method to total up qty and display 1 unique record
select ser#, <b>count(*) </b> as count, <b>sum(qty)</b> as total from file <b>group by </b>ser#
View Answer
| June 9, 2011 1:44 PM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG
select ser#, <b>count(*) </b> as count, <b>sum(qty)</b> as total from file <b>group by </b>ser#
View Answer
| June 9, 2011 1:44 PM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG
Opening Domino backups of an AS/400 tape on a Windows PC and converting the
NSF files are OS agnostic. If you have a client and access/privledges to the files, you can open them. An NSF file can go from one OS to the other without doing anything. You can have Domino clusters with different OSs.
View Answer
| June 8, 2011 8:11 PM
AS/400, AS/400 backup, Backup, Domino backup
NSF files are OS agnostic. If you have a client and access/privledges to the files, you can open them. An NSF file can go from one OS to the other without doing anything. You can have Domino clusters with different OSs.
View Answer
| June 8, 2011 8:11 PM
AS/400, AS/400 backup, Backup, Domino backup
AS/400 query join
Hi, If I got your requirement correctly, then I believe below query can help you:- SELECT EMP_NAME FROM MASTER A WHERE NOT EXISTS (SELECT * FROM SECONDARY B WHERE A.EMP_ID = B.EMP_ID AND B.DATE = YOUR_DATE) Regards Piyush
View Answer
| June 8, 2011 5:53 PM
AS/400 administration, AS/400 Query, AS/400 Query Select Records, V6R1
Hi, If I got your requirement correctly, then I believe below query can help you:- SELECT EMP_NAME FROM MASTER A WHERE NOT EXISTS (SELECT * FROM SECONDARY B WHERE A.EMP_ID = B.EMP_ID AND B.DATE = YOUR_DATE) Regards Piyush
View Answer
| June 8, 2011 5:53 PM
AS/400 administration, AS/400 Query, AS/400 Query Select Records, V6R1
Free IT Book: The Data Warehouse Mentor
twitted http://twitter.com/#!/batye1
View Answer
| June 7, 2011 6:29 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
twitted http://twitter.com/#!/batye1
View Answer
| June 7, 2011 6:29 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Adding a scheduled job
I do not believe you can add an automatic ENTER key. But, you can change your program to check to see if it is running in BATCH mode and then ignore the process that requires the ENTER key.
View Answer
| June 7, 2011 12:41 PM
AS/400 job scheduler, AS/400 jobs, Call PGM Command, Job scheduling
I do not believe you can add an automatic ENTER key. But, you can change your program to check to see if it is running in BATCH mode and then ignore the process that requires the ENTER key.
View Answer
| June 7, 2011 12:41 PM
AS/400 job scheduler, AS/400 jobs, Call PGM Command, Job scheduling
Want to delete objects of type ‘File’ except ‘source physical file’
A source file should have an attribute of PF-SRC So first you would need to delete LF objects, then PF objects. If there is on a single library or two, the easist way without doing any coding is using a User defined PDM option. If you do WRKOBJPPDM xxxx where xxxx is your library name. [...]
View Answer
| June 7, 2011 12:35 PM
AS/400 Database File, AS400 physical file, Database Files, DSPOBJD, Physical Files
A source file should have an attribute of PF-SRC So first you would need to delete LF objects, then PF objects. If there is on a single library or two, the easist way without doing any coding is using a User defined PDM option. If you do WRKOBJPPDM xxxx where xxxx is your library name. [...]
View Answer
| June 7, 2011 12:35 PM
AS/400 Database File, AS400 physical file, Database Files, DSPOBJD, Physical Files
Hard drive formatting
You would want to use a third party application. I like Paragon Hard Disk utility. Basically, anything that will erase and wipe your HD using an algorithm to jumble any left over information is what you want. I think Paragon uses US DoD. Obviously, the most secure way is to get it shredded, but that [...]
View Answer
| June 3, 2011 12:57 PM
Data Security Program, Format Data command, Hard Drive Installation, Server Backup, Server Database, Server Security
You would want to use a third party application. I like Paragon Hard Disk utility. Basically, anything that will erase and wipe your HD using an algorithm to jumble any left over information is what you want. I think Paragon uses US DoD. Obviously, the most secure way is to get it shredded, but that [...]
View Answer
| June 3, 2011 12:57 PM
Data Security Program, Format Data command, Hard Drive Installation, Server Backup, Server Database, Server Security
Problem with AS/400 data transfer to Excel
Can you state what versions of the IBM i operating system you are on, and what version of Client access? You say you are using the Data transfer facility, so this creates a number of PC files which contain details of the transfer. Are you able to sanitise these and post them here? The usual [...]
View Answer
| June 3, 2011 7:46 AM
AS/400 Data File, AS/400 data transfer, AS400 Hex Invalid data, Client Access, excel, Exporting AS/400 to Excel
Can you state what versions of the IBM i operating system you are on, and what version of Client access? You say you are using the Data transfer facility, so this creates a number of PC files which contain details of the transfer. Are you able to sanitise these and post them here? The usual [...]
View Answer
| June 3, 2011 7:46 AM
AS/400 Data File, AS/400 data transfer, AS400 Hex Invalid data, Client Access, excel, Exporting AS/400 to Excel
Compare files in AS400
The size limitation is a known issue with the CMPPFM command. I have split the large files into smaller files when I needed to do that in the past. If you not worried about the sequence of the data, just what records are in one file but not the other, you can do that with [...]
View Answer
| June 2, 2011 8:05 PM
AS/400 command functions, AS/400 DB2, AS/400 File Sharing, CMPPFM
The size limitation is a known issue with the CMPPFM command. I have split the large files into smaller files when I needed to do that in the past. If you not worried about the sequence of the data, just what records are in one file but not the other, you can do that with [...]
View Answer
| June 2, 2011 8:05 PM
AS/400 command functions, AS/400 DB2, AS/400 File Sharing, CMPPFM
Free IT Book: Building Applications in the Cloud
just twited http://twitter.com/#!/batye1 batye1 ALEXANDER STEPHENS Ask & answer #tech questions with other #ITpros at @ITKE: bit.ly/986ff0
View Answer
| June 2, 2011 3:18 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
just twited http://twitter.com/#!/batye1 batye1 ALEXANDER STEPHENS Ask & answer #tech questions with other #ITpros at @ITKE: bit.ly/986ff0
View Answer
| June 2, 2011 3:18 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Restore System 38 file to iSeries V5R3
You do not say why you cannot restore it what commands have you used? what error messages are being issued? what does the help text on the messages tell you? Presumably your system can physically access the file, to get the data in the question the start point for me would be rstobj and quote [...]
View Answer
| June 2, 2011 8:18 AM
iSeries, iSeries Access, iSeries data center, V5R3
You do not say why you cannot restore it what commands have you used? what error messages are being issued? what does the help text on the messages tell you? Presumably your system can physically access the file, to get the data in the question the start point for me would be rstobj and quote [...]
View Answer
| June 2, 2011 8:18 AM
iSeries, iSeries Access, iSeries data center, V5R3
AS/400 520 c1001020
Hi Tom Yes got it frm Miami and received it in Toronto. I waited whole night. I do not know if I have any waranty because got it fron a dealer who buy and sells. It is just not moving anywhere. Any suggestion. MK
View Answer
| June 1, 2011 10:15 PM
AS/400, AS/400 administration, AS/400 performance, SRC C1001020
Hi Tom Yes got it frm Miami and received it in Toronto. I waited whole night. I do not know if I have any waranty because got it fron a dealer who buy and sells. It is just not moving anywhere. Any suggestion. MK
View Answer
| June 1, 2011 10:15 PM
AS/400, AS/400 administration, AS/400 performance, SRC C1001020
recovering a DDS
I don’t “think” so. At least, I’ve never seent it done. You can DSPFD and DSPFFD and get a lot of information about field and indicator usage, etc. but I’ve only heard of reconstructing CL programs from the object. Nothing else. errr … search for Alex Nubla RTVDBSRC
View Answer
| June 1, 2011 5:34 PM
AS/400
I don’t “think” so. At least, I’ve never seent it done. You can DSPFD and DSPFFD and get a lot of information about field and indicator usage, etc. but I’ve only heard of reconstructing CL programs from the object. Nothing else. errr … search for Alex Nubla RTVDBSRC
View Answer
| June 1, 2011 5:34 PM
AS/400
Color attribute lost in readc/update of subfile record.
You need to check every record again to set on or not the indicator. In the moment you update the subfile the status of all indicators used will be applied, so I think the hidden field is the only solution. This is the way we are using in the company I work for. Regards.
View Answer
| May 31, 2011 9:52 PM
iSeries V6R1, READC, SFLNXTCHG, Subfile
You need to check every record again to set on or not the indicator. In the moment you update the subfile the status of all indicators used will be applied, so I think the hidden field is the only solution. This is the way we are using in the company I work for. Regards.
View Answer
| May 31, 2011 9:52 PM
iSeries V6R1, READC, SFLNXTCHG, Subfile
SNDTCPSPLF Problem
Hi, the problem occurred here as well since the installation of the latest CUM PTF. Good news : there is a PTF out to fix it. For V5R4 it is SI42147. However, we seem to run into issues now that there are not enough ports available. The messages are TCP3701 preceded by a TCP100D. Nothing [...]
View Answer
| May 31, 2011 6:42 AM
AS/400, AS/400 Spool Files, CLP, iSeries, SNDTCPSPLF
Hi, the problem occurred here as well since the installation of the latest CUM PTF. Good news : there is a PTF out to fix it. For V5R4 it is SI42147. However, we seem to run into issues now that there are not enough ports available. The messages are TCP3701 preceded by a TCP100D. Nothing [...]
View Answer
| May 31, 2011 6:42 AM
AS/400, AS/400 Spool Files, CLP, iSeries, SNDTCPSPLF
