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
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
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
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 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 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
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
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
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
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
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
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
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
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
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
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
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?
Answer Question | July 14, 2010 12:43 PM
AS/400 File Extract, AS/400 SQL, 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
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