Transfer Data from AS400 to Excel using Reflection
I need help learning how to create a file transfer from the AS400 to an Excel spreadsheet using Reflection. I am not a “techie”; what I’ve learned has come from countless hours of using the “help” button and reading technical blogs. I knew how to create DTF requests when our company was using Client Access [...]
Answer Question
| May 20, 2011 5:08 AM
AS/400, AS/400 data transfer, AS/400 database, IBM Reflections, Reflection Data Transfer
I need help learning how to create a file transfer from the AS400 to an Excel spreadsheet using Reflection. I am not a “techie”; what I’ve learned has come from countless hours of using the “help” button and reading technical blogs. I knew how to create DTF requests when our company was using Client Access [...]
Answer Question
| May 20, 2011 5:08 AM
AS/400, AS/400 data transfer, AS/400 database, IBM Reflections, Reflection Data Transfer
How to determine what type of RAM in inside a remote computer
Hi All, Is there a free application that can give me the following information about any remote client I remote into to 1. type of ram and speed 2. processor 3. type of video card Any help is much appreciated Regards Shane
Answer Question
| May 13, 2011 9:55 AM
Client Access, RAM, Remote access
Hi All, Is there a free application that can give me the following information about any remote client I remote into to 1. type of ram and speed 2. processor 3. type of video card Any help is much appreciated Regards Shane
Answer Question
| May 13, 2011 9:55 AM
Client Access, RAM, Remote access
DB2 Process automatically Shutdown
At our site using IBM DB2 database there some problem with our DB2 Database services stop automatically .Error log shown the DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Thanks, Nilesh
Answer Question
| May 13, 2011 8:51 AM
AS/400 database, AS/400 database administration, AS/400 DB2, DB2
At our site using IBM DB2 database there some problem with our DB2 Database services stop automatically .Error log shown the DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Thanks, Nilesh
Answer Question
| May 13, 2011 8:51 AM
AS/400 database, AS/400 database administration, AS/400 DB2, DB2
Printing separator pages with job number, user name etc
Our print spool files print with separator pages. They seem to print based on user profiles. I cannot find it in the user profile descriptions or in the output queue descriptions. Is it possible to define them some where else?
Answer Question
| May 17, 2011 10:07 PM
AS/400 print jobs, AS/400 printing, AS/400 Spool Files, Output Queues, Spool file output queue
Our print spool files print with separator pages. They seem to print based on user profiles. I cannot find it in the user profile descriptions or in the output queue descriptions. Is it possible to define them some where else?
Answer Question
| May 17, 2011 10:07 PM
AS/400 print jobs, AS/400 printing, AS/400 Spool Files, Output Queues, Spool file output queue
Updated PSFCFG Exit Program
Does anyone have any information on a new way to write an exit program for the IBM PSFCFG writer??? I found one in an IBM manual about 5 years ago (2006 or 7). Just wondering if any new code is out there to create a mapping exit program. Thanks
Answer Question
| May 25, 2011 5:42 PM
Exit programs, IBM, InfoPrint, InfoPrint Mapping Exit Program, User Exit Program FTP
Does anyone have any information on a new way to write an exit program for the IBM PSFCFG writer??? I found one in an IBM manual about 5 years ago (2006 or 7). Just wondering if any new code is out there to create a mapping exit program. Thanks
Answer Question
| May 25, 2011 5:42 PM
Exit programs, IBM, InfoPrint, InfoPrint Mapping Exit Program, User Exit Program FTP
Single commitment control in RPGLE program
I have a rpgle program that uses 3-4 sql statements to update and insert data in 3-4 tables . Now what i want is that when program runs successfully then only these changes in tables should reflect else roll back . So for this is there any way to provide a single commitment control for [...]
Answer Question
| May 17, 2011 4:18 PM
RPGLE Program, SQL statements, SQLRPGLE, V6R1
I have a rpgle program that uses 3-4 sql statements to update and insert data in 3-4 tables . Now what i want is that when program runs successfully then only these changes in tables should reflect else roll back . So for this is there any way to provide a single commitment control for [...]
Answer Question
| May 17, 2011 4:18 PM
RPGLE Program, SQL statements, SQLRPGLE, V6R1
On overflow in Unix IBM COBOL
stringing a name into a field with a area causing overflow. area is defined as using linkage, but no linkage size defined. overflow only happens with a VERY LONG name. Routine has existed in production for several years, never had too long of name before.
Answer Question
| May 13, 2011 3:04 PM
COBOL, Overflow Error CPF5004, RPG overflow, Unix, Unix administration
stringing a name into a field with a area causing overflow. area is defined as using linkage, but no linkage size defined. overflow only happens with a VERY LONG name. Routine has existed in production for several years, never had too long of name before.
Answer Question
| May 13, 2011 3:04 PM
COBOL, Overflow Error CPF5004, RPG overflow, Unix, Unix administration
Completed IT Knowledge Exchange Profile? Earn points!
What’s a community without a face? Let your fellow IT Knowledge Exchange members know a little more about you and your expertise by filling out your public profile and uploading a photo. Then put the link to your profile in the discussion area below to claim your 10 knowledge points, good toward our current contest! [...]
Answer Question
| May 18, 2011 2:26 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
What’s a community without a face? Let your fellow IT Knowledge Exchange members know a little more about you and your expertise by filling out your public profile and uploading a photo. Then put the link to your profile in the discussion area below to claim your 10 knowledge points, good toward our current contest! [...]
Answer Question
| May 18, 2011 2:26 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Twinax AS/400 printer failure
Hi, I have a fault with my AS400. Current setup includes 4 twinax consoles connected to 4 twinax printers. I’m having a problem with PRT02. It suddenly stopped printing. The device status shows ‘Powered off or not available’. I tried to ‘Start’ the device under the Work with Printers menu but I get a message [...]
Answer Question
| May 20, 2011 2:44 PM
AS/400, AS/400 print errors, AS/400 printers, AS/400 printing
Hi, I have a fault with my AS400. Current setup includes 4 twinax consoles connected to 4 twinax printers. I’m having a problem with PRT02. It suddenly stopped printing. The device status shows ‘Powered off or not available’. I tried to ‘Start’ the device under the Work with Printers menu but I get a message [...]
Answer Question
| May 20, 2011 2:44 PM
AS/400, AS/400 print errors, AS/400 printers, AS/400 printing
Design 2 Column DFU Screen
I have 37 fields in the data records and I would like to display input dfu screen using two columns as input.
Answer Question
| May 12, 2011 6:15 PM
AS/400 administration, AS/400 Data Reports, AS400 DFU, DFU
I have 37 fields in the data records and I would like to display input dfu screen using two columns as input.
Answer Question
| May 12, 2011 6:15 PM
AS/400 administration, AS/400 Data Reports, AS400 DFU, DFU
Client Access printer setup
I replaced the parallel cable to my Epson FX-880 printer with a D-Link 311P print server, and ever since then my Client Access printer sessions start with “Windows Default Printer” even though the .ws file specifies the Epson printer. I never had this problem until I installed the DP-311P. I am using CA v6.1 on [...]
Answer Question
| May 17, 2011 6:08 PM
Client Access, Client Access Printing, D-Link, Windows XP
I replaced the parallel cable to my Epson FX-880 printer with a D-Link 311P print server, and ever since then my Client Access printer sessions start with “Windows Default Printer” even though the .ws file specifies the Epson printer. I never had this problem until I installed the DP-311P. I am using CA v6.1 on [...]
Answer Question
| May 17, 2011 6:08 PM
Client Access, Client Access Printing, D-Link, Windows XP
Embedded SQL in RPGLE hdr, dtl fetch for subfile build
I am trying to join a header and a detail file and select all fields into data structures defined as external(filename). D dswtchdr E DS EXTNAME(wtchdr) D dswtcdet E DS EXTNAME(wtcdet) C $CreateCsr Begsr C/EXEC SQL C+ prepare S1 from :sqlstmt C/end-exec * C/EXEC SQL C+ declare C1 scroll cursor for S1 C/end-exec C EndSr [...]
Answer Question
| May 12, 2011 4:46 PM
AS/400 Subfiles, Embedded SQL, Header, SQL Server, SQLRPGLE
I am trying to join a header and a detail file and select all fields into data structures defined as external(filename). D dswtchdr E DS EXTNAME(wtchdr) D dswtcdet E DS EXTNAME(wtcdet) C $CreateCsr Begsr C/EXEC SQL C+ prepare S1 from :sqlstmt C/end-exec * C/EXEC SQL C+ declare C1 scroll cursor for S1 C/end-exec C EndSr [...]
Answer Question
| May 12, 2011 4:46 PM
AS/400 Subfiles, Embedded SQL, Header, SQL Server, SQLRPGLE
Can we change length of CSV File
Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the [...]
Answer Question
| May 11, 2011 11:22 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format
Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the [...]
Answer Question
| May 11, 2011 11:22 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format
use Data connection wizard / Microsoft query to get data from as400 to excel 2007
Hi, I know the way to download data from as400 to excel 2007. It can be done by using Data connection wizard or Microsoft query. However, when using (1) Data connection wizard, i don’t know which kind of database i should choose. ODBC DSN or Other / advanced ? after choosing the kind of database, [...]
Answer Question
| May 12, 2011 6:33 AM
AS/400, Data connection wizard, Excel 2007, Microsoft Query, ODBC
Hi, I know the way to download data from as400 to excel 2007. It can be done by using Data connection wizard or Microsoft query. However, when using (1) Data connection wizard, i don’t know which kind of database i should choose. ODBC DSN or Other / advanced ? after choosing the kind of database, [...]
Answer Question
| May 12, 2011 6:33 AM
AS/400, Data connection wizard, Excel 2007, Microsoft Query, ODBC
Fault tolerance on a web server
What is the best way to have fault tolerance on our web server? We have a few backup machines all identical that get replicated via scripts every 10 minutes. How cab we automatically fail over to another already configured box if the primary production machine fails? Is this some DNS magic?
Answer Question
| May 22, 2011 7:41 PM
DNS, DNS server, Fault tolerance, Scripting, Web Server, Web server administration, Web servers
What is the best way to have fault tolerance on our web server? We have a few backup machines all identical that get replicated via scripts every 10 minutes. How cab we automatically fail over to another already configured box if the primary production machine fails? Is this some DNS magic?
Answer Question
| May 22, 2011 7:41 PM
DNS, DNS server, Fault tolerance, Scripting, Web Server, Web server administration, Web servers
Hard drive formatting
When formatting a hard drive of a server that is going to be donated how can I be certain that the data is gone? Is there a program or application I can run? Is there a standard procedure for this? Or does everyone remove the hard drives?
Answer Question
| June 6, 2011 7:11 PM
Data Security Program, Format Data command, Hard Drive Installation, Server Backup, Server Database, Server Security
When formatting a hard drive of a server that is going to be donated how can I be certain that the data is gone? Is there a program or application I can run? Is there a standard procedure for this? Or does everyone remove the hard drives?
Answer Question
| June 6, 2011 7:11 PM
Data Security Program, Format Data command, Hard Drive Installation, Server Backup, Server Database, Server Security
How can I list users whose status is disabled on AS/400 ?
Hello everybody ! I have to make a cl program in order to list users whose status is disabled. I wanted to know if someone had tips for me. Thanks
Answer Question
| May 17, 2011 4:50 PM
AS/400 programming, AS/400 Reports, AS/400 user profiles, CL programs
Hello everybody ! I have to make a cl program in order to list users whose status is disabled. I wanted to know if someone had tips for me. Thanks
Answer Question
| May 17, 2011 4:50 PM
AS/400 programming, AS/400 Reports, AS/400 user profiles, CL programs
Process Execution error – CD
Receive the below CD error: from one of the process when tried NDM CD error CDE0200 Escape 40 Message . . . . : Process execution not allowed. The Process Manager is not allowing execution of processes at this time. Session limits may have been met, or process execution may have been explicitly [...]
Answer Question
| May 13, 2011 1:25 PM
Business Process Execution Language, Process Manager, V6R1
Receive the below CD error: from one of the process when tried NDM CD error CDE0200 Escape 40 Message . . . . : Process execution not allowed. The Process Manager is not allowing execution of processes at this time. Session limits may have been met, or process execution may have been explicitly [...]
Answer Question
| May 13, 2011 1:25 PM
Business Process Execution Language, Process Manager, V6R1
Find/Replace/Reformat Text in COBOL or CL400
As part of a rebranding exercise I need to create a program to find/replace variable length text within a file. I know I can do this easily enough via INSPECT/REPLACE (or maybe QCLSCAN in a CL) but has anybody got ideas about how to reformat afterwards (data in the file is stored typically in multiple [...]
Answer Question
| May 9, 2011 10:17 AM
CL programming, CL programs, CL/400, COBOL/400
As part of a rebranding exercise I need to create a program to find/replace variable length text within a file. I know I can do this easily enough via INSPECT/REPLACE (or maybe QCLSCAN in a CL) but has anybody got ideas about how to reformat afterwards (data in the file is stored typically in multiple [...]
Answer Question
| May 9, 2011 10:17 AM
CL programming, CL programs, CL/400, COBOL/400
How to handle Null value in COBOL/400.
I have created a view that have Null value.I have populated this field on the basis of some conditions.But when i am reading this view in COBOL program it is going in infinite loop & reading the same record.
Answer Question
| May 12, 2011 5:49 AM
COBOL, COBOL Programs, COBOL/400, COBOL/400 Errors
I have created a view that have Null value.I have populated this field on the basis of some conditions.But when i am reading this view in COBOL program it is going in infinite loop & reading the same record.
Answer Question
| May 12, 2011 5:49 AM
COBOL, COBOL Programs, COBOL/400, COBOL/400 Errors
