Spooled File to PC and back to AS/400
Good morning, Is there a way to transfer spooled file output to a PC or server for storage and if necessary, at a later date, transfer it back to the AS/400? We have alot of spooled file output on our system that is out of date and I was wondering if there was a way [...]
Answer Question
| May 23, 2006 8:55 AM
AS/400, Printing
Good morning, Is there a way to transfer spooled file output to a PC or server for storage and if necessary, at a later date, transfer it back to the AS/400? We have alot of spooled file output on our system that is out of date and I was wondering if there was a way [...]
Answer Question
| May 23, 2006 8:55 AM
AS/400, Printing
WRKNAMSMTP updating from CL
I am sure that this question has been asked many times before but have never seen any answers. Since there is no UPDNAMSMTP command how can I update the System alias table programatically from CL or RPG ?
Answer Question
| December 7, 2009 6:01 AM
CLP, Exchange, RPG, RPGLE
I am sure that this question has been asked many times before but have never seen any answers. Since there is no UPDNAMSMTP command how can I update the System alias table programatically from CL or RPG ?
Answer Question
| December 7, 2009 6:01 AM
CLP, Exchange, RPG, RPGLE
command execution
thanks a lot!! for the help… but meanwhile i have got another problem…in my project- i have to use COMPILE commands such as CRTPF, CRTCLPPGM, CRTRPGPGM and so on…in a program and this has to be transparent to the user. in CL these programs cannot be used… how can i do this? plz help me [...]
Answer Question
| November 21, 2010 4:04 AM
Application development, AS/400, CLP, RPG
thanks a lot!! for the help… but meanwhile i have got another problem…in my project- i have to use COMPILE commands such as CRTPF, CRTCLPPGM, CRTRPGPGM and so on…in a program and this has to be transparent to the user. in CL these programs cannot be used… how can i do this? plz help me [...]
Answer Question
| November 21, 2010 4:04 AM
Application development, AS/400, CLP, RPG
IPDS spool file transfer to PC
Hi, Is it possible to transfer and IPDS spool file from an AS/400 to a PC? If so, what is the best/preferred way to accomplish this? Thanks, MissieStar
Answer Question
| December 7, 2009 3:03 PM
AS/400, Printing
Hi, Is it possible to transfer and IPDS spool file from an AS/400 to a PC? If so, what is the best/preferred way to accomplish this? Thanks, MissieStar
Answer Question
| December 7, 2009 3:03 PM
AS/400, Printing
Program Status Data Structure
Hi All, For position 191 – 198 in the SDS, is this always the Date the Job Entered the system? For example, we have a CL that starts at 23:50 on say 5/10, it does some processing and on the way out it calls an RPG at say 0:35 on 5/11. Will the date in [...]
Answer Question
| December 7, 2009 1:54 PM
Application development, AS/400, CLP, RPG, RPGLE
Hi All, For position 191 – 198 in the SDS, is this always the Date the Job Entered the system? For example, we have a CL that starts at 23:50 on say 5/10, it does some processing and on the way out it calls an RPG at say 0:35 on 5/11. Will the date in [...]
Answer Question
| December 7, 2009 1:54 PM
Application development, AS/400, CLP, RPG, RPGLE
souce file listing
hi all! i wanna know how can i retrieve the names of the components of a Source Physical File i.e. the names of the souce code (members) within a particular Source Physical File…i want ot retrieve the names and store in a database file and later use them for subfile operations. kindly help me out!!!!!! [...]
Answer Question
| December 7, 2009 8:15 AM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE
hi all! i wanna know how can i retrieve the names of the components of a Source Physical File i.e. the names of the souce code (members) within a particular Source Physical File…i want ot retrieve the names and store in a database file and later use them for subfile operations. kindly help me out!!!!!! [...]
Answer Question
| December 7, 2009 8:15 AM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE
migration of rpg to web
we are trying to migrate from rpg to new technoloygy and we are in confused as which technology to proceed. We want to use db2/400 (existing tables and database) , but use some new techonology insted of RPG. Any reference would greatly help us. Some say go for .NET and some others for Java. I [...]
Answer Question
| August 15, 2011 9:35 PM
AS/400
we are trying to migrate from rpg to new technoloygy and we are in confused as which technology to proceed. We want to use db2/400 (existing tables and database) , but use some new techonology insted of RPG. Any reference would greatly help us. Some say go for .NET and some others for Java. I [...]
Answer Question
| August 15, 2011 9:35 PM
AS/400
STRPCCMD
I am trying to use this command to open a PDF document from an iSeries ‘green screen’ It all works okay until I try to open one with a large path name – the command can only handle 123 characters. Does anyone know a way to get around this ? An API perhaps.
Answer Question
| May 10, 2006 6:27 AM
AS/400, RPGLE
I am trying to use this command to open a PDF document from an iSeries ‘green screen’ It all works okay until I try to open one with a large path name – the command can only handle 123 characters. Does anyone know a way to get around this ? An API perhaps.
Answer Question
| May 10, 2006 6:27 AM
AS/400, RPGLE
Performance Problem
We are experiencing intermittant performance problems most likely related to the update of a file that saves emails sent to customers. The problem may be related to a 10,000 byte text field for the body of the email message and/or the size of this file (2 million records). The file has one index and is [...]
Answer Question
| December 6, 2009 2:38 PM
AS/400, Data analysis, Database, DataCenter, DB2, Exchange, Oracle, SQL, Storage, Tech support
We are experiencing intermittant performance problems most likely related to the update of a file that saves emails sent to customers. The problem may be related to a 10,000 byte text field for the body of the email message and/or the size of this file (2 million records). The file has one index and is [...]
Answer Question
| December 6, 2009 2:38 PM
AS/400, Data analysis, Database, DataCenter, DB2, Exchange, Oracle, SQL, Storage, Tech support
AS400 JOURNALING
Hi. I have a production system that sends journals to a developement system. On the dev system, I caused a record to be created in a file with one key field that is specified UNIQUE. Later, journals from the production system were applied and now I have a record with the same key field but [...]
Answer Question
| December 6, 2009 4:37 PM
AS/400
Hi. I have a production system that sends journals to a developement system. On the dev system, I caused a record to be created in a file with one key field that is specified UNIQUE. Later, journals from the production system were applied and now I have a record with the same key field but [...]
Answer Question
| December 6, 2009 4:37 PM
AS/400
Prompting for and passing partial search criteria to queries
I?ve built a query, based on table containing public school student demographic data, using query utilities (i5/os, V5R3) which prompts for a value when run. The criteria in the ?select records? panel is FIELDLASTNAME EQ :FIELDLASTNAME. When I run STRQMQRY QMQRY(LIBRARY/QUERYNAME) ALWQRYDFN(*YES) QMFORM(*QMQRY) from the a command line, the system prompts me for FIELDLASTNAME. This [...]
Answer Question
| December 6, 2009 3:29 PM
AS/400, DB2 Universal Database
I?ve built a query, based on table containing public school student demographic data, using query utilities (i5/os, V5R3) which prompts for a value when run. The criteria in the ?select records? panel is FIELDLASTNAME EQ :FIELDLASTNAME. When I run STRQMQRY QMQRY(LIBRARY/QUERYNAME) ALWQRYDFN(*YES) QMFORM(*QMQRY) from the a command line, the system prompts me for FIELDLASTNAME. This [...]
Answer Question
| December 6, 2009 3:29 PM
AS/400, DB2 Universal Database
Record locking (or lack of it)
Bare with me a minute before you throw rocks, but is there a difference in record locking between a Chain and Read? Here’s what I’m looking at. We have a control file that contains the next note number. In all our applications we either chain or setll/read the control file, get the number, add one [...]
Answer Question
| May 3, 2006 2:22 PM
Application development, RPGLE
Bare with me a minute before you throw rocks, but is there a difference in record locking between a Chain and Read? Here’s what I’m looking at. We have a control file that contains the next note number. In all our applications we either chain or setll/read the control file, get the number, add one [...]
Answer Question
| May 3, 2006 2:22 PM
Application development, RPGLE
AS400 Console
What effects are caused if you vary off your console session on the AS400 and you do not have any other consoles to take over? I want to move my console to another location in my DataCenter, but I have to disconnect it from the AS400 and reconnect it. Will varying the device off to [...]
Answer Question
| May 3, 2006 10:55 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
What effects are caused if you vary off your console session on the AS400 and you do not have any other consoles to take over? I want to move my console to another location in my DataCenter, but I have to disconnect it from the AS400 and reconnect it. Will varying the device off to [...]
Answer Question
| May 3, 2006 10:55 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
Office/Excel 2003 and CA Express
We just upgraded MS office from 97 to 2003. Problem is since the upgrade, 1 in house user and a few remote users no longer access a Excel download file from the 400 (using a .dtf). Get message “Errors were detected in VDR.xls” “Damage to the file was so extensive that repairs were not possible. [...]
Answer Question
| May 4, 2006 3:37 PM
AS/400, Desktops, Management, Microsoft Office, Microsoft Windows, OS, Security, Servers, SQL Server
We just upgraded MS office from 97 to 2003. Problem is since the upgrade, 1 in house user and a few remote users no longer access a Excel download file from the 400 (using a .dtf). Get message “Errors were detected in VDR.xls” “Damage to the file was so extensive that repairs were not possible. [...]
Answer Question
| May 4, 2006 3:37 PM
AS/400, Desktops, Management, Microsoft Office, Microsoft Windows, OS, Security, Servers, SQL Server
ILE Program won’t compile
Hi, I’m just starting to get into ILE and i’ve created a Module with a with a Prototype, Procedure and Procedure-Interface definition. The problem is program from where i am trying to call the procedure. I won’t compile. I get the error “The name or indicator is not defined.” There some where in the calling [...]
Answer Question
| December 6, 2009 4:45 PM
AS/400, RPGLE
Hi, I’m just starting to get into ILE and i’ve created a Module with a with a Prototype, Procedure and Procedure-Interface definition. The problem is program from where i am trying to call the procedure. I won’t compile. I get the error “The name or indicator is not defined.” There some where in the calling [...]
Answer Question
| December 6, 2009 4:45 PM
AS/400, RPGLE
Delete files from IFS based on last used age
I need a non-C program that will delete files from a directory and its subdirectories in the IFS based on a user specified number of days since the last time it was used. Does anyone have such a program or product (or a suggestion for the easiest way to accomplish this)?
Answer Question
| May 1, 2006 11:11 AM
Application development, AS/400
I need a non-C program that will delete files from a directory and its subdirectories in the IFS based on a user specified number of days since the last time it was used. Does anyone have such a program or product (or a suggestion for the easiest way to accomplish this)?
Answer Question
| May 1, 2006 11:11 AM
Application development, AS/400
route mail with fax service in sbs 2003
i have a sbs 2003 on my network and i configure him to get all the fax of my company, the only problem is that when i configure him to route all the incoming fax to some mail it does not seem to work, i check the event log and i get error 32083 and [...]
Answer Question
| April 27, 2006 3:30 PM
Access, Access control, AIM, Application security, Availability, backdoors, Backup & recovery, Bandwidth, Biometrics, Brightmail, Browsers, Budgeting, Business/IT alignment, Career development, CipherTrust, ClearSwift, CLP, Compliance, configuration, CRM, Current threats, Data analysis, Database, DataCenter, Desktops, Digital certificates, Disaster Recovery, Encryption, Ethernet, Exchange, Exchange security, FDDI, filtering, Firewalls, Forensics, Frame Relay, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Management, McAfee, MessageLabs, Microsoft Office, Microsoft Windows, Network protocols, Network security, Networking, OS, Outsourcing, Patch management, patching, PEN testing, Performance management, Ping, Platform Security, Policies, Postini, Project management, provisioning, Regulations, Risk management, Rockliffe, ROI & cost justification, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SQL Server, SSL/TLS, standards, Storage, Symantec, TrendMicro, Trojans, Vendors, Viruses, VPN, vulnerability management, Web development, Web security, Web services, Web Services Standards, Wireless, worms
i have a sbs 2003 on my network and i configure him to get all the fax of my company, the only problem is that when i configure him to route all the incoming fax to some mail it does not seem to work, i check the event log and i get error 32083 and [...]
Answer Question
| April 27, 2006 3:30 PM
Access, Access control, AIM, Application security, Availability, backdoors, Backup & recovery, Bandwidth, Biometrics, Brightmail, Browsers, Budgeting, Business/IT alignment, Career development, CipherTrust, ClearSwift, CLP, Compliance, configuration, CRM, Current threats, Data analysis, Database, DataCenter, Desktops, Digital certificates, Disaster Recovery, Encryption, Ethernet, Exchange, Exchange security, FDDI, filtering, Firewalls, Forensics, Frame Relay, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Management, McAfee, MessageLabs, Microsoft Office, Microsoft Windows, Network protocols, Network security, Networking, OS, Outsourcing, Patch management, patching, PEN testing, Performance management, Ping, Platform Security, Policies, Postini, Project management, provisioning, Regulations, Risk management, Rockliffe, ROI & cost justification, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SQL Server, SSL/TLS, standards, Storage, Symantec, TrendMicro, Trojans, Vendors, Viruses, VPN, vulnerability management, Web development, Web security, Web services, Web Services Standards, Wireless, worms
Generating Excel spread sheets from Sequel on the iseries
I produce an excel spread sheet from sequel on the as400 and e-mail it to a user. The user performs some data entry on the spread sheet. The spread sheet is then transfered to a AS400 Physical file and a program is called that updates a AS400 data base. The problem is when they enter [...]
Answer Question
| December 6, 2009 8:48 AM
Application development, AS/400, Data analysis, Development, RPG, RPGLE
I produce an excel spread sheet from sequel on the as400 and e-mail it to a user. The user performs some data entry on the spread sheet. The spread sheet is then transfered to a AS400 Physical file and a program is called that updates a AS400 data base. The problem is when they enter [...]
Answer Question
| December 6, 2009 8:48 AM
Application development, AS/400, Data analysis, Development, RPG, RPGLE
Monitoring Tape Drives
Hello everybody, Well, I’m trying to write in C or CL a program that will monitor the different Tape Drives to know when and by who the drives are vary on and vary off. Does anyone as an example or can give me some infos to start because I’m really lost… Thanks in advance, Pierre.
Answer Question
| December 6, 2009 6:13 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter
Hello everybody, Well, I’m trying to write in C or CL a program that will monitor the different Tape Drives to know when and by who the drives are vary on and vary off. Does anyone as an example or can give me some infos to start because I’m really lost… Thanks in advance, Pierre.
Answer Question
| December 6, 2009 6:13 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter
HOUSE KEEPING STREAM FILES
I would like to write a utility which housekeeps stream files in the ifs based upon how many days ago the file was CREATED. Does any body know an API for this (an API which is easy enough to work with ‘RPG’ and/or ‘CL’ and NOT ‘C’) The DSPLNK CL command doesn’t provide the creation [...]
Answer Question
| April 26, 2006 9:13 PM
AS/400, CLP, DataCenter, RPG, RPGLE
I would like to write a utility which housekeeps stream files in the ifs based upon how many days ago the file was CREATED. Does any body know an API for this (an API which is easy enough to work with ‘RPG’ and/or ‘CL’ and NOT ‘C’) The DSPLNK CL command doesn’t provide the creation [...]
Answer Question
| April 26, 2006 9:13 PM
AS/400, CLP, DataCenter, RPG, RPGLE
