RPG ILE Debugging
How can I STRDBG for an interactive job that’s already running executing an RPG ILE program. Program already compiled with #all debug view, but no way to predict when the production program is going to fail.
Answer Question
| November 19, 2009 12:24 PM
AS/400, RPG
How can I STRDBG for an interactive job that’s already running executing an RPG ILE program. Program already compiled with #all debug view, but no way to predict when the production program is going to fail.
Answer Question
| November 19, 2009 12:24 PM
AS/400, RPG
Getting SHRPOOL Pool to Work
I have added SHRPOOL1 to the pool definitions for one of my subsystems. I also changed all the routing entries to use this memory pool as well. I’ve been watching the memory pool with WRKSHRPOOL for most of the day and it appears that nothing is running in that pool. Some jobs have been running [...]
Answer Question
| November 19, 2009 3:51 PM
AS/400
I have added SHRPOOL1 to the pool definitions for one of my subsystems. I also changed all the routing entries to use this memory pool as well. I’ve been watching the memory pool with WRKSHRPOOL for most of the day and it appears that nothing is running in that pool. Some jobs have been running [...]
Answer Question
| November 19, 2009 3:51 PM
AS/400
export sql server to iseries files
when I attempt to export a file most vchar and char fields default to datalink type via odbc. The iseries does not like the datalink type as then it can’t find the link. When I try to force the vchar field it creates the file but then on the copy tells me the field is [...]
Answer Question
| November 11, 2005 8:53 AM
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
when I attempt to export a file most vchar and char fields default to datalink type via odbc. The iseries does not like the datalink type as then it can’t find the link. When I try to force the vchar field it creates the file but then on the copy tells me the field is [...]
Answer Question
| November 11, 2005 8:53 AM
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Client Access
I am trying to connect to a old AS/400 ( Model 9406 – 300 running on V3R2M0 ) which is not in production, only being used for Inquiery purposes, using Client Access version 5.50.134.0 I get the following error CWBSY1000 – Communication Error while validating security information on system. The AS400 cannot ping to the [...]
Answer Question
| November 15, 2005 11:54 PM
AS/400, DataCenter, Networking, Ping, Tech support
I am trying to connect to a old AS/400 ( Model 9406 – 300 running on V3R2M0 ) which is not in production, only being used for Inquiery purposes, using Client Access version 5.50.134.0 I get the following error CWBSY1000 – Communication Error while validating security information on system. The AS400 cannot ping to the [...]
Answer Question
| November 15, 2005 11:54 PM
AS/400, DataCenter, Networking, Ping, Tech support
RTMCONSOLE on HMC/AS400 I-SERIES 520
Hi All, I am using a software called HALCYON on a multi partitioned I-SERIES controlled by a Hardware Management Console. The full system saves are scheduled using the Halcyon job scheduler. This scheduler does not kick off the backup unless the consoles are signed on to RTMCONSOLE( Restricted Task Manager )and then put on screensaver. [...]
Answer Question
| November 11, 2005 11:21 PM
AS/400, Hardware, Linux, Routers
Hi All, I am using a software called HALCYON on a multi partitioned I-SERIES controlled by a Hardware Management Console. The full system saves are scheduled using the Halcyon job scheduler. This scheduler does not kick off the backup unless the consoles are signed on to RTMCONSOLE( Restricted Task Manager )and then put on screensaver. [...]
Answer Question
| November 11, 2005 11:21 PM
AS/400, Hardware, Linux, Routers
CPD0160 – Message
Greetings! I am presently receiving the following message. Any pointers on overcoming this obstacle would be greatly appreciated. Additional Message Information Message ID . . . . . . : CPD0160 Severity . . . . . . . : 30 Message type . . . . . : Diagnostic Date sent . . . [...]
Answer Question
| November 10, 2010 1:19 PM
AS/400
Greetings! I am presently receiving the following message. Any pointers on overcoming this obstacle would be greatly appreciated. Additional Message Information Message ID . . . . . . : CPD0160 Severity . . . . . . . : 30 Message type . . . . . : Diagnostic Date sent . . . [...]
Answer Question
| November 10, 2010 1:19 PM
AS/400
report of cpu ultilization by the user
hi all, i want to take the report of cpu ultilization by the user at the end of month from the object *mgtcol in qmpgdata library.i need help to extract the parameter jbcpu from the object *mgtcol. thanks in advance
Answer Question
| November 10, 2005 12:58 AM
AS/400
hi all, i want to take the report of cpu ultilization by the user at the end of month from the object *mgtcol in qmpgdata library.i need help to extract the parameter jbcpu from the object *mgtcol. thanks in advance
Answer Question
| November 10, 2005 12:58 AM
AS/400
synon software installation
hi all, i want to instal synon software in my system(v5r3).for that i need the details of vendor or download site or anyother contact person to instal that software. thanks in advance.
Answer Question
| November 10, 2005 12:52 AM
AS/400, Development
hi all, i want to instal synon software in my system(v5r3).for that i need the details of vendor or download site or anyother contact person to instal that software. thanks in advance.
Answer Question
| November 10, 2005 12:52 AM
AS/400, Development
QSYSOPR not authorized to RTVUSRPRF
I have a job that runs continually in it’s own subsystem under the QSYSOPR profile. I need to retrieve print default values of the user that triggers the job to run. When I use the RTVUSRPRF command or QSYRUSRI API, I receive USER NOT AUTHORIZED message. I looked at the authorities for QSYSOPR and RTVUSRPRF [...]
Answer Question
| November 19, 2009 9:06 PM
AS/400, RPG
I have a job that runs continually in it’s own subsystem under the QSYSOPR profile. I need to retrieve print default values of the user that triggers the job to run. When I use the RTVUSRPRF command or QSYRUSRI API, I receive USER NOT AUTHORIZED message. I looked at the authorities for QSYSOPR and RTVUSRPRF [...]
Answer Question
| November 19, 2009 9:06 PM
AS/400, RPG
Name that computer?
Warning: this may be historic (1970′s, PDP-11, etc.) or might be fictional. Don’t loose sleep over this (although you might could get some additional insight around 9pm EST;-) And please don’t flame me either. Minicomputer, comparable phyiscal size to PDP-11 appears to be two CPU units 3-5 feet height, but one may be open reel [...]
Answer Question
| November 11, 2005 4:13 PM
390, AS/400, DB2, Hardware, Hewlett-Packard Application Server, Linux, Mainframe, Servers
Warning: this may be historic (1970′s, PDP-11, etc.) or might be fictional. Don’t loose sleep over this (although you might could get some additional insight around 9pm EST;-) And please don’t flame me either. Minicomputer, comparable phyiscal size to PDP-11 appears to be two CPU units 3-5 feet height, but one may be open reel [...]
Answer Question
| November 11, 2005 4:13 PM
390, AS/400, DB2, Hardware, Hewlett-Packard Application Server, Linux, Mainframe, Servers
Need appointments generated from AS400 to be imported to users Outlook 2003 Calendars
Need help please: Have Exchange 2003 in Windows 2003 using Outlook 2003. We also house an AS400 without any email applications. Need to find a way for Exchange to accept appointments from the AS400 and to be placed directly into the recipients calendar. Any ideas? Any help would be greatly appreciated. Mark
Answer Question
| November 11, 2010 11:25 AM
AS/400, Exchange
Need help please: Have Exchange 2003 in Windows 2003 using Outlook 2003. We also house an AS400 without any email applications. Need to find a way for Exchange to accept appointments from the AS400 and to be placed directly into the recipients calendar. Any ideas? Any help would be greatly appreciated. Mark
Answer Question
| November 11, 2010 11:25 AM
AS/400, Exchange
QsnBeep
Does anybody know if I can use the QsnBeep (QSNAPI) several times in a RPG-ILE but with different ‘beeps’. For example, there are 2 possible errors in an interactive program, can I generate 2 different error-sounds ? Or does it ALWAYS uses the PC5250 host bell ? Although I think it is another story with [...]
Answer Question
| November 11, 2005 10:57 AM
AS/400, DataCenter, DB2 Universal Database, Development, ERP, RPG, Tech support
Does anybody know if I can use the QsnBeep (QSNAPI) several times in a RPG-ILE but with different ‘beeps’. For example, there are 2 possible errors in an interactive program, can I generate 2 different error-sounds ? Or does it ALWAYS uses the PC5250 host bell ? Although I think it is another story with [...]
Answer Question
| November 11, 2005 10:57 AM
AS/400, DataCenter, DB2 Universal Database, Development, ERP, RPG, Tech support
DDS / RPG – cursor management
My question is regarding cursor management. My application displays list of members (using RPG and DSPF). There is one input field per row, in which the user enteres the option he wishes to preform on the selected row. The RPG processes the selected row, by the given option. My question is: When the RPG completes [...]
Answer Question
| November 19, 2009 9:44 AM
RPG
My question is regarding cursor management. My application displays list of members (using RPG and DSPF). There is one input field per row, in which the user enteres the option he wishes to preform on the selected row. The RPG processes the selected row, by the given option. My question is: When the RPG completes [...]
Answer Question
| November 19, 2009 9:44 AM
RPG
ILE Cobol and IP Sockets
Hi, I am programming in ILE Cobol and want to use IP Socket to communicate with an application on a Linux server. However, I cannot get the content of the C++ variable ‘errno’ returned back into the Cobol program. I have declared ‘errno’ as external, ‘call procedure’ the sockets functions and have bound the whole [...]
Answer Question
| November 9, 2005 8:00 AM
AS/400
Hi, I am programming in ILE Cobol and want to use IP Socket to communicate with an application on a Linux server. However, I cannot get the content of the C++ variable ‘errno’ returned back into the Cobol program. I have declared ‘errno’ as external, ‘call procedure’ the sockets functions and have bound the whole [...]
Answer Question
| November 9, 2005 8:00 AM
AS/400
making CHGOBJOWN faster
Is there a way to make a command like CHGOBJOWN run faster. Rather than waiting to get an exclusive lock on the object I would rather see the command try once and move on. I still need to capture the fact that the change failed, I just want it to fail quicker if it is [...]
Answer Question
| November 10, 2005 2:33 PM
AS/400, DB2 Universal Database
Is there a way to make a command like CHGOBJOWN run faster. Rather than waiting to get an exclusive lock on the object I would rather see the command try once and move on. I still need to capture the fact that the change failed, I just want it to fail quicker if it is [...]
Answer Question
| November 10, 2005 2:33 PM
AS/400, DB2 Universal Database
Access SQL Server 2003 database from ISeries
Hello everyone, I have searched the web for SQL Server/ISeries connectivity and have come across some interesting options: java, JDBC etc. But they have not been very clear. I understand that it is not a simple task, but has anyone successfully accessed an SQL Server database from ISeries using SQL and Java or any other [...]
Answer Question
| November 18, 2009 10:51 AM
Access, AS/400, Database, DB2 Universal Database, RPG, SQL Server
Hello everyone, I have searched the web for SQL Server/ISeries connectivity and have come across some interesting options: java, JDBC etc. But they have not been very clear. I understand that it is not a simple task, but has anyone successfully accessed an SQL Server database from ISeries using SQL and Java or any other [...]
Answer Question
| November 18, 2009 10:51 AM
Access, AS/400, Database, DB2 Universal Database, RPG, SQL Server
How do I retrieve the JOB/USER/NBR for a spoolfile generated by a GUI program?
I have a GUI program which HAS to run interactively that generates a spoolfile. The HTTP job (Which is what I correctly retrieved using RTVJOBA & QUSRJOBI)is: Job: VOI User: QTMHHTTP Number: 303484 But the job that my spoolfile has is: Job: QPRTJOB User: <My user ID> Number: 303384 Does anyone know how to retrieve [...]
Answer Question
| November 18, 2009 7:37 AM
AS/400, Database, DB2 Universal Database, RPG
I have a GUI program which HAS to run interactively that generates a spoolfile. The HTTP job (Which is what I correctly retrieved using RTVJOBA & QUSRJOBI)is: Job: VOI User: QTMHHTTP Number: 303484 But the job that my spoolfile has is: Job: QPRTJOB User: <My user ID> Number: 303384 Does anyone know how to retrieve [...]
Answer Question
| November 18, 2009 7:37 AM
AS/400, Database, DB2 Universal Database, RPG
DATE, TIME and TIMESTAMP fields in the database files
Hi I created DATE, TIME and TIMESTAMP fields in a physical file. But I donot know how to populate the values to these fields from a COBOL program. When I include the file in a cobol program, the date field comes as FILLER PIC X(10), the tome field comes as FILLER PIC X(8) and the [...]
Answer Question
| November 9, 2005 7:22 AM
AS/400, Database, DB2 Universal Database, RPG
Hi I created DATE, TIME and TIMESTAMP fields in a physical file. But I donot know how to populate the values to these fields from a COBOL program. When I include the file in a cobol program, the date field comes as FILLER PIC X(10), the tome field comes as FILLER PIC X(8) and the [...]
Answer Question
| November 9, 2005 7:22 AM
AS/400, Database, DB2 Universal Database, RPG
Using Sql.Request with iSeries ODBC driver
I am attempting to use the sql.request fucntion in excel (add-in from xlodbc.xla) to access data on a AS/400 using the iSeries ODBC driver, but I can’t get it to work. I beleive the problem is in the connection_string. I am using “DSN=iSeries; UID=guest; PWD=123″ but it does not seem to connect to the AS/400 [...]
Answer Question
| November 7, 2005 12:56 PM
AS/400, Microsoft Office
I am attempting to use the sql.request fucntion in excel (add-in from xlodbc.xla) to access data on a AS/400 using the iSeries ODBC driver, but I can’t get it to work. I beleive the problem is in the connection_string. I am using “DSN=iSeries; UID=guest; PWD=123″ but it does not seem to connect to the AS/400 [...]
Answer Question
| November 7, 2005 12:56 PM
AS/400, Microsoft Office
changing system value QUTCOFFSET
Hi, we recently upgraded to V5R3 and can no longer change system value QUTCOFFSET.
Answer Question
| November 18, 2009 11:47 AM
AS/400
Hi, we recently upgraded to V5R3 and can no longer change system value QUTCOFFSET.
Answer Question
| November 18, 2009 11:47 AM
AS/400
