AS/400 user ID which i do not want to be disconnected at all.
I have a user id which i do not want to be disconnected at all. Is that possible since i have set a system value for QDSCJOB. All profiles need to be disconnected if not active for above 15 mins, therafter after another 30 mins the interactive job is ended. But i need this one [...]
Answer Question
| February 9, 2011 3:56 AM
AS/400, AS/400 user administration, AS/400 user permissions, AS/400 user profiles, iSeries
I have a user id which i do not want to be disconnected at all. Is that possible since i have set a system value for QDSCJOB. All profiles need to be disconnected if not active for above 15 mins, therafter after another 30 mins the interactive job is ended. But i need this one [...]
Answer Question
| February 9, 2011 3:56 AM
AS/400, AS/400 user administration, AS/400 user permissions, AS/400 user profiles, iSeries
Setup for Internet public can access the iSeries 170
I have a iSeries 170 running V4R5. It is on a LAN that has Internet access provided by a IP provider. I need to know what is needed so the Internet public can access the iSeries 170 and it HTTP servers that are running. I have run: wrkhdwrsc *cmn System: S105004M Type options, press Enter. [...]
Answer Question
| February 7, 2011 9:16 PM
AS/400 IP address, iSeries, LAN, V4R5
I have a iSeries 170 running V4R5. It is on a LAN that has Internet access provided by a IP provider. I need to know what is needed so the Internet public can access the iSeries 170 and it HTTP servers that are running. I have run: wrkhdwrsc *cmn System: S105004M Type options, press Enter. [...]
Answer Question
| February 7, 2011 9:16 PM
AS/400 IP address, iSeries, LAN, V4R5
Convert Spool File Tools
I am looking at using either Iseries Report Downloader or SpoolIt to convert spool files into an Excel format. Has anyone used these tools? Is there another tool I should look at using? What I want to accomplish is to take a spool file, strip out the page headers, breaks and pick and choose the data [...]
Answer Question
| February 10, 2011 8:55 PM
AS/400 Spool Files, AS/400 Spooled Files, Change Spooled File Attributes, Spool files
I am looking at using either Iseries Report Downloader or SpoolIt to convert spool files into an Excel format. Has anyone used these tools? Is there another tool I should look at using? What I want to accomplish is to take a spool file, strip out the page headers, breaks and pick and choose the data [...]
Answer Question
| February 10, 2011 8:55 PM
AS/400 Spool Files, AS/400 Spooled Files, Change Spooled File Attributes, Spool files
Continue to get the error ’425 Not able to open data connection’ when doing an FTP ‘Put’ from my i Series to my customer’s i Series.
Happens whether I use passive or port mode. Appears the FTP is getting to my customer’s i Series because I see the following message below in their Qsysopr. Any suggestions? Message ID . . . . . . : TCP2617 Severity . . . . . . . : 20 Message type . . . [...]
Answer Question
| February 4, 2011 7:10 PM
AS/400 FTP, FTP, FTP 425 Error
Happens whether I use passive or port mode. Appears the FTP is getting to my customer’s i Series because I see the following message below in their Qsysopr. Any suggestions? Message ID . . . . . . : TCP2617 Severity . . . . . . . : 20 Message type . . . [...]
Answer Question
| February 4, 2011 7:10 PM
AS/400 FTP, FTP, FTP 425 Error
Save IXS CL program
Does anyone out there have a CL program which saves all the objects on an IXS?
Answer Question
| February 7, 2011 7:06 PM
CL Program, CL programming, CLPROGRAM
Does anyone out there have a CL program which saves all the objects on an IXS?
Answer Question
| February 7, 2011 7:06 PM
CL Program, CL programming, CLPROGRAM
*UTCD field type
Hi All, We have just upgraded from V5.4 to V6.1 and have run into a problem with a program that does a sndpgmmsg of CPF1241. The date and time parameters are data types *UTCD and *UTCT. What should be used to populate those parameters when sending the message? Everything I’ve tried so far gives me [...]
Answer Question
| February 24, 2011 2:33 PM
*UTCD, AS/400 Dataset, AS400 Data type, iSeries V6R1
Hi All, We have just upgraded from V5.4 to V6.1 and have run into a problem with a program that does a sndpgmmsg of CPF1241. The date and time parameters are data types *UTCD and *UTCT. What should be used to populate those parameters when sending the message? Everything I’ve tried so far gives me [...]
Answer Question
| February 24, 2011 2:33 PM
*UTCD, AS/400 Dataset, AS400 Data type, iSeries V6R1
How to know if AS/400 data is journaling properly?
How we can know that Data is Journaling proparly or not?
Answer Question
| February 5, 2011 5:50 AM
AS/400, AS/400 Data Reports, AS/400 database administration, AS/400 journaling
How we can know that Data is Journaling proparly or not?
Answer Question
| February 5, 2011 5:50 AM
AS/400, AS/400 Data Reports, AS/400 database administration, AS/400 journaling
I can connect locally to iSeries via telnet
I can connect locally using telnet, but cannot do it from the outside world. Any pointers out there would be appreciated. thanks, Bob
Answer Question
| February 16, 2011 2:50 AM
AS/400 connectivity, iSeries Telnet, Telnet, V5R4
I can connect locally using telnet, but cannot do it from the outside world. Any pointers out there would be appreciated. thanks, Bob
Answer Question
| February 16, 2011 2:50 AM
AS/400 connectivity, iSeries Telnet, Telnet, V5R4
Defining AS/400 Data Areas
I need to access a numeric data area. I do not know at program exection time the library of the data area. This is defined within the program.
Answer Question
| March 9, 2011 1:10 AM
AS/400, AS/400 Data File, AS/400 Library, Data Area
I need to access a numeric data area. I do not know at program exection time the library of the data area. This is defined within the program.
Answer Question
| March 9, 2011 1:10 AM
AS/400, AS/400 Data File, AS/400 Library, Data Area
Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!
We’re always looking for great resources to share with the community, so here’s your chance to share what’s in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you’ll never forget. Don’t have a favorite tech blog? [...]
Answer Question
| August 23, 2011 4:25 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
We’re always looking for great resources to share with the community, so here’s your chance to share what’s in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you’ll never forget. Don’t have a favorite tech blog? [...]
Answer Question
| August 23, 2011 4:25 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Implementing a chat using SQLServer Service Broker – how good an idea it is?
We are designing a chat engine. That’s basically a message queue. When our customers will adopt it, there will be thousands of people chatting. In our company we use SQLServer heavily, and this is an argument for preferring Service Broker over MSMQ. Is Service Broker a good idea? Each chat session will be a new [...]
Answer Question
| February 3, 2011 4:23 PM
Chat applications, SQL 2008, SQL Server, SQL Server 2008
We are designing a chat engine. That’s basically a message queue. When our customers will adopt it, there will be thousands of people chatting. In our company we use SQLServer heavily, and this is an argument for preferring Service Broker over MSMQ. Is Service Broker a good idea? Each chat session will be a new [...]
Answer Question
| February 3, 2011 4:23 PM
Chat applications, SQL 2008, SQL Server, SQL Server 2008
Earn 50 knowledge points by tweeting out our iPad contest!
We’ll give you 50 knowledge points for sending out a tweet about our iPad contest, happening now through February 16th! Spread the word, earn points, and qualify yourself for an iPad or Amazon.com gift card! Contest details at the Community Blog.
Answer Question
| February 3, 2011 3:51 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
We’ll give you 50 knowledge points for sending out a tweet about our iPad contest, happening now through February 16th! Spread the word, earn points, and qualify yourself for an iPad or Amazon.com gift card! Contest details at the Community Blog.
Answer Question
| February 3, 2011 3:51 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
How to get different font sizes to print on an iSeries report
I am trying to change an AS400 print file so that we can print some fields larger than others. The file is printing to a laser printer via client access print emulation session. I have tried to use the FONT keyword but it’s not making a difference. Any ideas how I can acomplish this? Thanks
Answer Question
| March 14, 2012 3:27 PM
AS/400 Print Problems, AS/400 printing, iSeries, iSeries printing
I am trying to change an AS400 print file so that we can print some fields larger than others. The file is printing to a laser printer via client access print emulation session. I have tried to use the FONT keyword but it’s not making a difference. Any ideas how I can acomplish this? Thanks
Answer Question
| March 14, 2012 3:27 PM
AS/400 Print Problems, AS/400 printing, iSeries, iSeries printing
Ping the As/400 servers
Generally we communicate with two as/400 servers by using this Ping command . two servers are Seluas04 an usrias01 When i enter ,” Pin usrias01 ” On seluas04 then Following error Occured . Error–”No response from host within 1 seconds for connection verification 2.” You have any solution for that , Plz repply Bcoz job [...]
Answer Question
| February 7, 2011 9:20 AM
AS/400, AS/400 communication, AS/400 Server
Generally we communicate with two as/400 servers by using this Ping command . two servers are Seluas04 an usrias01 When i enter ,” Pin usrias01 ” On seluas04 then Following error Occured . Error–”No response from host within 1 seconds for connection verification 2.” You have any solution for that , Plz repply Bcoz job [...]
Answer Question
| February 7, 2011 9:20 AM
AS/400, AS/400 communication, AS/400 Server
SQL 9010 Error when using RUNSQLSTM
I have a CL program having the following RUNSQLSTM RUNSQLSTM SRCFILE(AMBDEV/MSRCAMB) SRCMBR(AMBJARRVK) COMMIT(*NONE) AMBJARRVK is a SQL member file in MSRCAMB source file having this SQL statment DELETE FROM GDPF WHERE GDUSID = ‘A365′ AND GDOID = ‘JAR’ I am receiving SQL9010 error when running the CL program… Any hint on where is the [...]
Answer Question
| May 16, 2012 8:03 AM
CL Program, CLPROGRAM, RUNSQLSTM, SQL error messages
I have a CL program having the following RUNSQLSTM RUNSQLSTM SRCFILE(AMBDEV/MSRCAMB) SRCMBR(AMBJARRVK) COMMIT(*NONE) AMBJARRVK is a SQL member file in MSRCAMB source file having this SQL statment DELETE FROM GDPF WHERE GDUSID = ‘A365′ AND GDOID = ‘JAR’ I am receiving SQL9010 error when running the CL program… Any hint on where is the [...]
Answer Question
| May 16, 2012 8:03 AM
CL Program, CLPROGRAM, RUNSQLSTM, SQL error messages
SNDTCPSPLF Problem
Hello all, I ran into an issue with SNDTCPSPLF. Here’s what the command looks like: SNDTCPSPLF RMTSYS(LOCALHOST) PRTQ('QUSRSYS/THISOUTQ') + FILE(&SPOOLFILE) JOB(*) SPLNBR(*LAST) + DESTTYP(*AS400) TRANSFORM(*NO) DLTSPLF(*NO) Where &SPOOLFILE is the name of the spoolfile. The spoolfile gets copied and everything is great. BUT, the user is changing to QTMPLPD. As far as I [...]
Answer Question
| May 31, 2011 7:57 PM
AS/400, AS/400 Spool Files, CLP, iSeries, SNDTCPSPLF
Hello all, I ran into an issue with SNDTCPSPLF. Here’s what the command looks like: SNDTCPSPLF RMTSYS(LOCALHOST) PRTQ('QUSRSYS/THISOUTQ') + FILE(&SPOOLFILE) JOB(*) SPLNBR(*LAST) + DESTTYP(*AS400) TRANSFORM(*NO) DLTSPLF(*NO) Where &SPOOLFILE is the name of the spoolfile. The spoolfile gets copied and everything is great. BUT, the user is changing to QTMPLPD. As far as I [...]
Answer Question
| May 31, 2011 7:57 PM
AS/400, AS/400 Spool Files, CLP, iSeries, SNDTCPSPLF
New IBM monitors not created
I’m trying to create a message monitor, setup works fine with no errors but when I click the OK button the monitor isn’t listed in the window. I don’t see the monitor anywhere, I don’t get any messages, and there isn’t anything in the joblog that even hints at an issue. I also tried a [...]
Answer Question
| June 23, 2011 4:10 PM
IBM, Management Central, Monitors, V5R3
I’m trying to create a message monitor, setup works fine with no errors but when I click the OK button the monitor isn’t listed in the window. I don’t see the monitor anywhere, I don’t get any messages, and there isn’t anything in the joblog that even hints at an issue. I also tried a [...]
Answer Question
| June 23, 2011 4:10 PM
IBM, Management Central, Monitors, V5R3
Available Certifications for AS/400 Developers
Hi All, I have been working on AS400 as a Developer on RPG IV, CL and DB2/400 for around 4 years and i wanted to do any certification regards to AS400. Actually I’m planned to write RPG IV Certification Exam(Certification No :268), but recently i came to know from my friend that this certification is [...]
Answer Question
| April 4, 2012 12:47 PM
AS/400, AS/400 certification, AS/400 development, RPG IV
Hi All, I have been working on AS400 as a Developer on RPG IV, CL and DB2/400 for around 4 years and i wanted to do any certification regards to AS400. Actually I’m planned to write RPG IV Certification Exam(Certification No :268), but recently i came to know from my friend that this certification is [...]
Answer Question
| April 4, 2012 12:47 PM
AS/400, AS/400 certification, AS/400 development, RPG IV
How to create AS/400 user defined commands
I tried to create user defined command, but couldn’t understand the paramters to input in CRTCMD. CMD > MSG > MYLIB PGM > MESSAGE > MYLIB SRCFILE QCMDSRC *LIBL SRCMBR *CMD THDSAFE *NO Here, I have created one CLP MYLIB/MESSAGE to run just one simple command DSPMSG. however I’m not sure what values to be [...]
Answer Question
| February 4, 2011 9:53 AM
AS/400, AS/400 command functions, AS/400 commands, AS/400 user permissions, User Defined Fields
I tried to create user defined command, but couldn’t understand the paramters to input in CRTCMD. CMD > MSG > MYLIB PGM > MESSAGE > MYLIB SRCFILE QCMDSRC *LIBL SRCMBR *CMD THDSAFE *NO Here, I have created one CLP MYLIB/MESSAGE to run just one simple command DSPMSG. however I’m not sure what values to be [...]
Answer Question
| February 4, 2011 9:53 AM
AS/400, AS/400 command functions, AS/400 commands, AS/400 user permissions, User Defined Fields
Using Query on 4 different files
Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the customers [...]
Answer Question
| February 7, 2011 1:02 AM
AS/400 File Sharing, AS/400 Query, AS/400 Reports, Query
Hi i have four different files each containing a Customer name ,number and sales amounts ,each file is for a different quarter of the year ,i would like to join the four files so that i can produce a report which lists across the page by quarter the sales for each customer,however not all the customers [...]
Answer Question
| February 7, 2011 1:02 AM
AS/400 File Sharing, AS/400 Query, AS/400 Reports, Query
