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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

creating VL, PO, data selection for CL
Hi, Is it possible to create VL, PO, data selection for a CL program?

Answer Question   |  March 17, 2012  4:59 AM
Control Language Programming

Calling query/400 through CL
Hi, Is it possible to call query/400 through a CL program? Please suggest some idea.. Thanks, Jayashree V.      

Answer Question   |  March 17, 2012  4:45 AM
CL, Query/400

iSeries Printing
I need to print two forms on one page. Using CHGPRTF attribute MULTIUP which is supposed to allow two pages to print on one side. But it does not work. Any assistance would be appreciated.

Answer Question   |  March 19, 2012  10:53 PM
Chgprtf, iSeries printing

User cannot run a job that another use has access to do
How do I give a user access to run a job?

Answer Question   |  March 17, 2012  10:01 PM
as400/DB2, rights