Issue with HMC backup
Hi This is my first trail ……I followed the following process to take backup for the HMC… From HMC Software Maintainance —> HMC—->Backup critical console data—->backup to DVD on local system. Here I am getting problem with media and giving error like not a compatable disk. Also asking for a farmat the DISK. For this [...]
Answer Question
| May 15, 2012 7:20 PM
AS/400 administration, HMC V6.1
Hi This is my first trail ……I followed the following process to take backup for the HMC… From HMC Software Maintainance —> HMC—->Backup critical console data—->backup to DVD on local system. Here I am getting problem with media and giving error like not a compatable disk. Also asking for a farmat the DISK. For this [...]
Answer Question
| May 15, 2012 7:20 PM
AS/400 administration, HMC V6.1
Favorite printer in AS 400 environment
Just curious if anyone has a fav printer in the AS-400 world. The HP4200 / 4250 has worked well for us and unfortunately can no longer buy new. Suggestions?
Answer Question
| February 28, 2012 3:55 PM
AS 400, AS/400 printers
Just curious if anyone has a fav printer in the AS-400 world. The HP4200 / 4250 has worked well for us and unfortunately can no longer buy new. Suggestions?
Answer Question
| February 28, 2012 3:55 PM
AS 400, AS/400 printers
How do I start a query on AS/400 with a parameter
Can I start a query on AS/400 and give a variable or a parameter to that query for record selection (RCDSLT)?
Answer Question
| March 17, 2012 2:29 PM
AS/400
Can I start a query on AS/400 and give a variable or a parameter to that query for record selection (RCDSLT)?
Answer Question
| March 17, 2012 2:29 PM
AS/400
Chinese as secondary laungage on iSeries
Hi, I need to setup Chinese (Lang caode – 2989) as secondary lang. on V6R1. I have parimary 2924 English installed on my box. So where else i need to configure to get Chinese login prompt/ main and all sub menus. Best wishes. Chirag Sheth
Answer Question
| March 17, 2012 10:14 AM
AS 400
Hi, I need to setup Chinese (Lang caode – 2989) as secondary lang. on V6R1. I have parimary 2924 English installed on my box. So where else i need to configure to get Chinese login prompt/ main and all sub menus. Best wishes. Chirag Sheth
Answer Question
| March 17, 2012 10:14 AM
AS 400
Subratct 90 days from the System Date
Hi friends, it´s me again. I need to reorganize a file called payments to a file called paymentsH (H means Historical) On the file payments I have 11 million records since 2005 and I need only the last 90 days, but I need thats information on the historical file. The field PAYDATE was configurated below [...]
Answer Question
| February 28, 2012 9:03 PM
RPG/400 program-defined disk output file
Hi friends, it´s me again. I need to reorganize a file called payments to a file called paymentsH (H means Historical) On the file payments I have 11 million records since 2005 and I need only the last 90 days, but I need thats information on the historical file. The field PAYDATE was configurated below [...]
Answer Question
| February 28, 2012 9:03 PM
RPG/400 program-defined disk output file
Job got hung and not able to clearing off from the system
I’ve a job in QINTER which went to hung status.tried ENDJOB *IMMED and ENDJOBABN…nothing didn’t work..did anybody has experienced this kind problem ever.If so pls let me know..? Even if i try with endinga SBS….SBS also will go for hung status..?
Answer Question
| March 17, 2012 3:33 PM
AS/400, iSeries, jobs, Subsystems
I’ve a job in QINTER which went to hung status.tried ENDJOB *IMMED and ENDJOBABN…nothing didn’t work..did anybody has experienced this kind problem ever.If so pls let me know..? Even if i try with endinga SBS….SBS also will go for hung status..?
Answer Question
| March 17, 2012 3:33 PM
AS/400, iSeries, jobs, Subsystems
iSeries Tool
Hi, Is there a tool to automate transfer of source and objects from one iSeries to another? Is there a tool to compare two source codes from different iSeries box? Thank you
Answer Question
| March 17, 2012 9:57 AM
iSeries, iSeries application development tools, iSeries applications, iSeries data center, iSeries programming commands, iSeries RPG programming
Hi, Is there a tool to automate transfer of source and objects from one iSeries to another? Is there a tool to compare two source codes from different iSeries box? Thank you
Answer Question
| March 17, 2012 9:57 AM
iSeries, iSeries application development tools, iSeries applications, iSeries data center, iSeries programming commands, iSeries RPG programming
Compatible driver for DLQ-3500 printer
What is Compatible driver of DLQ-3500 Epson printer for AS400
Answer Question
| March 17, 2012 9:34 AM
AS/400
What is Compatible driver of DLQ-3500 Epson printer for AS400
Answer Question
| March 17, 2012 9:34 AM
AS/400
SQL400 Strip non-numeric from a column
Hello everyone, Is there a way to strip non-numeric characters from a char column? Example: I have a Clients file, with column “Telephone Number” (CLPhone, 20, A). The thing is, phone number for many clients is filled with different formats. Example1: (123-12345) Example2: 123 12345 Example3: 123/12345 And even worse . Is there a way to select [...]
Answer Question
| March 17, 2012 6:54 AM
AS/400, non-numeric, SQL/400, Striping
Hello everyone, Is there a way to strip non-numeric characters from a char column? Example: I have a Clients file, with column “Telephone Number” (CLPhone, 20, A). The thing is, phone number for many clients is filled with different formats. Example1: (123-12345) Example2: 123 12345 Example3: 123/12345 And even worse . Is there a way to select [...]
Answer Question
| March 17, 2012 6:54 AM
AS/400, non-numeric, SQL/400, Striping
Using iSeries as linked server in SQL Server 2012 Express
I downloaded SQL Server 2012 Express in order to attempt to create a database on a PC which has links to data living on our iSeries. I can’t use the OLE DB2 extension from Microsoft since it doesn’t work on SQL Server Express. So, I figured out (with Google’s help) that I could run this [...]
Answer Question
| March 17, 2012 6:12 PM
AS/400, iSeries, Linked Server, SQL Server
I downloaded SQL Server 2012 Express in order to attempt to create a database on a PC which has links to data living on our iSeries. I can’t use the OLE DB2 extension from Microsoft since it doesn’t work on SQL Server Express. So, I figured out (with Google’s help) that I could run this [...]
Answer Question
| March 17, 2012 6:12 PM
AS/400, iSeries, Linked Server, SQL Server
EZ-Rad performance tuning software
Has anyone used the EZ-Rad performance tuning software from MB Software and Consulting? What’s your experince with it and the company? Thanks.
Answer Question
| March 17, 2012 1:17 PM
AS/400, performance tuning
Has anyone used the EZ-Rad performance tuning software from MB Software and Consulting? What’s your experince with it and the company? Thanks.
Answer Question
| March 17, 2012 1:17 PM
AS/400, performance tuning
DST Queue
how to configure an DST Queue. How to send an Message through DST to InboxCan someone help me out
Answer Question
| March 17, 2012 10:28 AM
DST
how to configure an DST Queue. How to send an Message through DST to InboxCan someone help me out
Answer Question
| March 17, 2012 10:28 AM
DST
Single Page subfile
hi i am try to create a single page sub file for record updation with option 1-create 2-update when i put 2 in opt. field and press page down then option field showing 2 in every row in sub file please any one help me i am new in subfile programing thanks in advance
Answer Question
| March 17, 2012 7:28 AM
AS400 Subfile
hi i am try to create a single page sub file for record updation with option 1-create 2-update when i put 2 in opt. field and press page down then option field showing 2 in every row in sub file please any one help me i am new in subfile programing thanks in advance
Answer Question
| March 17, 2012 7:28 AM
AS400 Subfile
Time Elapsed
I am getting the wrong result in the %DIFF function. See following code: D total_hours s 9 2 inz(0) D time1 S t inz(T’12.00.00′) D time2 S t inz(T’13.38.00′) /Free total_hours = %diff(time2 : time1 : *h); *inLR = *on; /End-Free C RETURN I was expecting 1.38. and I am getting 1.00. Any suggestions?
Answer Question
| March 17, 2012 6:57 PM
AS/400
I am getting the wrong result in the %DIFF function. See following code: D total_hours s 9 2 inz(0) D time1 S t inz(T’12.00.00′) D time2 S t inz(T’13.38.00′) /Free total_hours = %diff(time2 : time1 : *h); *inLR = *on; /End-Free C RETURN I was expecting 1.38. and I am getting 1.00. Any suggestions?
Answer Question
| March 17, 2012 6:57 PM
AS/400
Tape Catridges AS400
Hi I need to share Tape Volumes between two iSeries systems,Both systems were connected through BRMS Network.How od i accompalish this ?
Answer Question
| March 19, 2012 5:36 PM
AS/400, backups, BRMS, Tapes
Hi I need to share Tape Volumes between two iSeries systems,Both systems were connected through BRMS Network.How od i accompalish this ?
Answer Question
| March 19, 2012 5:36 PM
AS/400, backups, BRMS, Tapes
DB2 database on Iseries
Ho can I get the size of a DB2 data base on a iSeries platform
Answer Question
| March 17, 2012 10:44 AM
Database, iSeries
Ho can I get the size of a DB2 data base on a iSeries platform
Answer Question
| March 17, 2012 10:44 AM
Database, iSeries
Printer IP’s
How do I get a list of all my printer IP addresses in one report without having to go into the set up of each individual printer. I have 3000 and that would be a nightmare.
Answer Question
| March 17, 2012 5:48 PM
iSeries printing, Print management, Printer management
How do I get a list of all my printer IP addresses in one report without having to go into the set up of each individual printer. I have 3000 and that would be a nightmare.
Answer Question
| March 17, 2012 5:48 PM
iSeries printing, Print management, Printer management
Execute SQL SELECT via RUNSQLSTM error
Trying to execute SQL-statement “SELECT * FROM mylib/myfile” give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?
Answer Question
| March 17, 2012 4:42 PM
RUNSQLSTM, SELECT statement, SQL
Trying to execute SQL-statement “SELECT * FROM mylib/myfile” give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?
Answer Question
| March 17, 2012 4:42 PM
RUNSQLSTM, SELECT statement, SQL
sbs
how to add a new wrkstation r to tfr a job to a sbs
Answer Question
| February 28, 2012 6:12 AM
AS/400
how to add a new wrkstation r to tfr a job to a sbs
Answer Question
| February 28, 2012 6:12 AM
AS/400
Library is taking long time to save than before in BRMS
Hi, Greetings for the day! I write this email in reference to a query related to BRMS. There is one library which is taking a long time than usual, however there is nothing in the log where i could find the reason for it. Control group is running as batch under SBS-QCTL. There is no [...]
Answer Question
| March 17, 2012 5:18 AM
AS/400 BRMS
Hi, Greetings for the day! I write this email in reference to a query related to BRMS. There is one library which is taking a long time than usual, however there is nothing in the log where i could find the reason for it. Control group is running as batch under SBS-QCTL. There is no [...]
Answer Question
| March 17, 2012 5:18 AM
AS/400 BRMS
