questions related to commitment control in RPGLE
Hi everyone, I have a strange question about commitment control as following: the program , say PGMA, have commitment control on two files. of coz the two files have been journaled. Another program, say PGMB, will call PGMA to update the two files. Before the call to PGMA, I use QCMDEXC to call the CL [...]
Answer Question
| July 16, 2010 4:18 PM
AS/400, AS/400 commitment control, AS/400 jobs, STRCMTCTL
Hi everyone, I have a strange question about commitment control as following: the program , say PGMA, have commitment control on two files. of coz the two files have been journaled. Another program, say PGMB, will call PGMA to update the two files. Before the call to PGMA, I use QCMDEXC to call the CL [...]
Answer Question
| July 16, 2010 4:18 PM
AS/400, AS/400 commitment control, AS/400 jobs, STRCMTCTL
Web services for windows 7
Currently I have excel .xla addin with a macro that was created by the Microsoft Office 2003 Web Services Toolkit. Works fine with XP and Excel 2003. Now some users in office have Windows 7 and Excel 2003 and I have to remove the references to the mssoap30.dll and msxml6.dll in order to have the .xla [...]
Answer Question
| July 15, 2010 3:32 PM
Office 2003, Visual Basic for Applications, WebServices, Windows 7, Windows 7 in 2010
Currently I have excel .xla addin with a macro that was created by the Microsoft Office 2003 Web Services Toolkit. Works fine with XP and Excel 2003. Now some users in office have Windows 7 and Excel 2003 and I have to remove the references to the mssoap30.dll and msxml6.dll in order to have the .xla [...]
Answer Question
| July 15, 2010 3:32 PM
Office 2003, Visual Basic for Applications, WebServices, Windows 7, Windows 7 in 2010
AS400 Security Audit
How do you perform a security audit for user access on the AS400?
Answer Question
| July 15, 2010 1:50 PM
AS/400 security, AS/400 user administration, Security Audit
How do you perform a security audit for user access on the AS400?
Answer Question
| July 15, 2010 1:50 PM
AS/400 security, AS/400 user administration, Security Audit
MQ software upgrade
I am going to upgrade MQseries to latest version. I don’t know anything about MQ. Can somebody tell me what are the basic steps I need to follow? My machine is 9406-825 and os is V5R4M0
Answer Question
| July 23, 2010 12:08 PM
MQ for iSeries, OS upgrade, Software upgrades, V5R4M0
I am going to upgrade MQseries to latest version. I don’t know anything about MQ. Can somebody tell me what are the basic steps I need to follow? My machine is 9406-825 and os is V5R4M0
Answer Question
| July 23, 2010 12:08 PM
MQ for iSeries, OS upgrade, Software upgrades, V5R4M0
AS/400 file to Excel with Headers and Footers
I need to attach an Excel s/sheet to an email. I currently do that via the CPYTOIMPF as a CSV file but this doesnt give give me the true Excel Header row, which is a requirement. Is there any easy way to do this?
Answer Question
| July 16, 2010 12:08 PM
AS/400, CPYTOIMPF, Email attachments, excel
I need to attach an Excel s/sheet to an email. I currently do that via the CPYTOIMPF as a CSV file but this doesnt give give me the true Excel Header row, which is a requirement. Is there any easy way to do this?
Answer Question
| July 16, 2010 12:08 PM
AS/400, CPYTOIMPF, Email attachments, excel
Set DataTable name in returned data set
I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset. The stored procedure is being called from C#/.NET code. The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,… when the dataset is received on the .NET side. Is there a way to define [...]
Answer Question
| July 20, 2010 3:29 AM
C# .NET, DataTable name, iSeries SQL, SQL stored procedures
I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset. The stored procedure is being called from C#/.NET code. The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,… when the dataset is received on the .NET side. Is there a way to define [...]
Answer Question
| July 20, 2010 3:29 AM
C# .NET, DataTable name, iSeries SQL, SQL stored procedures
STRQMQRY: The variable should appear without quotes
In my cl the strqmqry I am passing 2 variables that are character but should be numeric when the query runs………….now they have the quotes around them……………..how do I get the quotes out of there so they are treated as numeric????
Answer Question
| July 15, 2010 9:33 PM
AS/400 Query, Query Manager, STRQMQRY
In my cl the strqmqry I am passing 2 variables that are character but should be numeric when the query runs………….now they have the quotes around them……………..how do I get the quotes out of there so they are treated as numeric????
Answer Question
| July 15, 2010 9:33 PM
AS/400 Query, Query Manager, STRQMQRY
Unable to log into AS/400
What does message “CPF1123 Function check occurred during sign on processing” mean?
Answer Question
| July 27, 2010 4:31 PM
AS/400 error messages, AS/400 login, iSeries, OS/400
What does message “CPF1123 Function check occurred during sign on processing” mean?
Answer Question
| July 27, 2010 4:31 PM
AS/400 error messages, AS/400 login, iSeries, OS/400
Sponsor Post: Join Us for the Identity Access Management Live Expert Chat on 7/20 at 11am ET
To compete in the new economy, organizations need to provide efficient and secure access to their internal applications and data for external entities, such as business partners, customers, and mobile employees. Join Microsoft’s Senior Technical Product Manager, Brjann Brekkan, on July 20 from 11am-2pm ET for Microsoft Business Ready Security – Identity Access Management. He [...]
Answer Question
| July 14, 2010 3:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange server software, Identity and access management, Linux, Lotus Domino, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
To compete in the new economy, organizations need to provide efficient and secure access to their internal applications and data for external entities, such as business partners, customers, and mobile employees. Join Microsoft’s Senior Technical Product Manager, Brjann Brekkan, on July 20 from 11am-2pm ET for Microsoft Business Ready Security – Identity Access Management. He [...]
Answer Question
| July 14, 2010 3:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange server software, Identity and access management, Linux, Lotus Domino, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
ENDJRNPF Shortcoming in V5R4
If in V6R1, issuing the command ENDJRNPF completes without any error even if a PF or LF of that PF is open in some other program, then what is the solution for shops that only have V5R4? I need to end journaling for files but the ENDJRNPF fails because some of the LFs for the [...]
Answer Question
| February 8, 2012 10:45 AM
ENDJRNPF, iseries v5r4, iSeries V6R1, PTFs
If in V6R1, issuing the command ENDJRNPF completes without any error even if a PF or LF of that PF is open in some other program, then what is the solution for shops that only have V5R4? I need to end journaling for files but the ENDJRNPF fails because some of the LFs for the [...]
Answer Question
| February 8, 2012 10:45 AM
ENDJRNPF, iseries v5r4, iSeries V6R1, PTFs
SNA & SSCL in iSeries AS/400
Where do we use SNA(Systems network Architecture) and SSL concepts in AS4/00 (iSERIES)
Answer Question
| July 15, 2010 10:49 PM
IBM Systems Network Architecture, iSeries AS/400, SNA
Where do we use SNA(Systems network Architecture) and SSL concepts in AS4/00 (iSERIES)
Answer Question
| July 15, 2010 10:49 PM
IBM Systems Network Architecture, iSeries AS/400, SNA
OUTQ Usage
How do I know the last time that an OUTQ in the iSeries was used
Answer Question
| July 13, 2010 7:20 PM
iSeries management, OUTQ, OUTQ management
How do I know the last time that an OUTQ in the iSeries was used
Answer Question
| July 13, 2010 7:20 PM
iSeries management, OUTQ, OUTQ management
File system in AS/400
What file system based AS/400(ISERIES) is? like windows NTFS etc. do we have any name for that? AS/400
Answer Question
| July 20, 2010 6:03 PM
file system as/400, iSeries AS/400
What file system based AS/400(ISERIES) is? like windows NTFS etc. do we have any name for that? AS/400
Answer Question
| July 20, 2010 6:03 PM
file system as/400, iSeries AS/400
Suggestions for modern replacement of AS/400
We are looking to retire our AS/400 machine, what is a suitable replacement? Our aging AS/400 machine is on its last legs. What modern system is a good fit? We have Oracle data on it for our front end server. Everything is backed up to tape library.
Answer Question
| July 15, 2010 5:27 PM
AS/400 upgrades, Oracle Database Migration, Tape Backups, Tape libraries
We are looking to retire our AS/400 machine, what is a suitable replacement? Our aging AS/400 machine is on its last legs. What modern system is a good fit? We have Oracle data on it for our front end server. Everything is backed up to tape library.
Answer Question
| July 15, 2010 5:27 PM
AS/400 upgrades, Oracle Database Migration, Tape Backups, Tape libraries
Remove (revoke) an user out of lib object authority ?
I added an user to access my lib (with authority *all) that user is no longer with company and i want to remove her out of that lib access./ please show me a simple way to delete her access in that lib. Thanks
Answer Question
| July 14, 2010 3:09 PM
Edit Object Authority, Library software, User Permissions
I added an user to access my lib (with authority *all) that user is no longer with company and i want to remove her out of that lib access./ please show me a simple way to delete her access in that lib. Thanks
Answer Question
| July 14, 2010 3:09 PM
Edit Object Authority, Library software, User Permissions
Changing User Authority/Securing System
Is there an easy way to change user authority to read on only on an open AS400 system that is menu driven? The ability to change data, add, update etc. is coded within the programs – in other words function key driven.
Answer Question
| July 14, 2010 1:20 PM
AS/400 Authorization List, AS/400 Permissions, AS/400 Security Data, AS/400 user permissions
Is there an easy way to change user authority to read on only on an open AS400 system that is menu driven? The ability to change data, add, update etc. is coded within the programs – in other words function key driven.
Answer Question
| July 14, 2010 1:20 PM
AS/400 Authorization List, AS/400 Permissions, AS/400 Security Data, AS/400 user permissions
Sponsor Post: Secure End Point Live Expert Chat – Tomorrow @ 11am ET
Join this expert chat tomorrow, July 13th from 11am-2pm ET, to learn how Microsoft Forefront solutions protect client and server operating systems from emerging threats and information loss, while enabling more secure access from virtually anywhere. Click here for reminder email to access the expert chat.
Answer Question
| July 12, 2010 2:27 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Endpoint security, Exchange server software, Linux, Lotus Domino, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Join this expert chat tomorrow, July 13th from 11am-2pm ET, to learn how Microsoft Forefront solutions protect client and server operating systems from emerging threats and information loss, while enabling more secure access from virtually anywhere. Click here for reminder email to access the expert chat.
Answer Question
| July 12, 2010 2:27 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Endpoint security, Exchange server software, Linux, Lotus Domino, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
How to read multi member Physical file through SQL?
How to read multi member Physical file through SQL?
Answer Question
| July 14, 2010 12:43 PM
AS/400 File Extract, AS/400 SQL, AS400 physical file
How to read multi member Physical file through SQL?
Answer Question
| July 14, 2010 12:43 PM
AS/400 File Extract, AS/400 SQL, AS400 physical file
How do I view information about access path in AS400 System?
How to view information about access path in AS400 System? How is the system differentiating access paths for file1 and file2 in AS400?
Answer Question
| July 13, 2010 12:18 PM
AS/400 Access Paths, AS/400 administration, AS400 physical file
How to view information about access path in AS400 System? How is the system differentiating access paths for file1 and file2 in AS400?
Answer Question
| July 13, 2010 12:18 PM
AS/400 Access Paths, AS/400 administration, AS400 physical file
iTera Issue
Hi, I have iTera HA 5.0 installed.While doing the regular check on DR box,in Mirrored Object Maintenance screen ,I find one object LOCK1191 in Lib DBSLIB is not being journalled.On checking the status of DBSLIB on production box,the status shows SYNCING.But this status remains as it is for last 2 days . How do I make [...]
Answer Question
| July 19, 2010 12:01 PM
Data Protection Manager, i5/OS, iSeries applications, iTera
Hi, I have iTera HA 5.0 installed.While doing the regular check on DR box,in Mirrored Object Maintenance screen ,I find one object LOCK1191 in Lib DBSLIB is not being journalled.On checking the status of DBSLIB on production box,the status shows SYNCING.But this status remains as it is for last 2 days . How do I make [...]
Answer Question
| July 19, 2010 12:01 PM
Data Protection Manager, i5/OS, iSeries applications, iTera
