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

Output file
I have an logical file,3 physical files and i need to create an output file which will extract all the data present in the files how can i do that using RPG.

Answer Question   |  March 19, 2012  4:23 PM
RPGILE

Using RPGLE Fixed Format keywords in Free Format
Hi, How can we use the various keywords in rpgle free format such as sub file next change, key list, etc. It would be more appreciable if some link for reference document is given. Thanks, Vivek Sharma

Answer Question   |  March 17, 2012  3:36 PM
Free Format, RPG ILE

IP address for local server
How do I find the IP address of a file server on my as400

Answer Question   |  March 17, 2012  9:31 PM
File Server, FTP, IP address, Server