Replace ” with ” in AS/400 string
Hi i have a string and want to replace all occurance of ” with “.Please let me know how can i accomplish this .

Answer Question   |  May 2, 2011  6:18 PM
AS/400, As/400 Object, RPGLE, String name

sql statement…..
Can someone take a look at this code and please tell me what i am doing wrong? SQL> INSERT INTO “CDAAS”.”INFORMATION”   2  VALUES (‘MBedfo’,'Maurice’,'Bedford’,'Maurice Bedford’,”,”,’02/02/1990′,’1234′,”,”,”); VALUES (‘MBedfo’,'Maurice’,'Bedford’,'Maurice Bedford’,”,”,’02/02/1990′,’1234′,”,”,”)         * ERROR at line 2: ORA-01722: invalid number

Answer Question   |  May 3, 2011  4:27 PM
Oracle 11g, SQL Server, SQL statement

DDM System File
Is there a system file that holds all DDM information or is it just contained and processed at the DDM file level?

Answer Question   |  May 3, 2011  3:10 PM
DDM, DDMDEVICE, iSeries, V5R4

SQL statement needed to remove characters
I have data in one of my columns in a table that I would like to remove via a SQL update statement.  In all cases, the data that I want to remove is the same 3 characters at the end of the varchar field.   How would I structure the SQL statement?

Answer Question   |  May 2, 2011  2:34 AM
SQL Server, SQL Server 2008, SQL statement, SQL tables

QMHOLHST sample program
Is anyone aware of a program which uses QMHOLHST (history log) API?

Answer Question   |  April 15, 2011  10:49 PM
API, History log, IBM i, QMHOLHST

Interactive command in CL
How to successfully compile a CL program that has an interactive command such as STRSEU?

Answer Question   |  May 2, 2011  2:13 PM
AS/400 - CL Command, CL Commands, STRSEU

OS/400 commands: RTVDSKINF
I do a RTVDSKINF and when collection completed a PRTDSKINF *SYS. On page 1 of the report it summarizes disk usage by object type with the ‘% of disk’ for each object type. However, the TOTAL does not add up to 100%. I get 90.16% on my report. Any ideas why????

Answer Question   |  May 2, 2011  2:01 PM
AS/400 command functions, AS/400 commands, OS/400, OS/400 command line, RTVDSKINF

AS400 – FTP
HI When iam FTPing the zip file from i series to unix server..iam getting the warning message like WARNING! 19 bare linefeeds received in ASCII mode .When iam doing on mu windows system it is ftping without any error messages.Could you pls sugget me what may be the error.  Thanks

Answer Question   |  May 2, 2011  12:25 PM
AS/400 FTP, ASCII, ASCII File, FTP

Send zip file via email
i have a physical file it contain lot of data,now my requirement is convert  this data into .zip file and after ziping that file  send send to client email -id how to do this?

Answer Question   |  April 16, 2011  10:28 AM
AS/400, AS/400 email, Zip Files

Batch Jobs in AS/400
Hi Group, We have an application developed in RPG/400, COBOL/400, CL/400 & ILE. There are few batch jobs that are supposed to be run at the End of the Day. The execution time for these batch jobs is very high.  What measures can be taken to reduce the down time?  Suppose we want to move [...]

Answer Question   |  April 25, 2012  1:52 AM
AS/400, AS/400 batch jobs, COBOL/400, RPG/400

S36Environment
Can I put files in another library other than QS36F? And use the library list bbamond@msn.com Thanks

Answer Question   |  April 12, 2011  9:47 PM
AS/400 Library, Library List, S/36, S36E

SRC Error
Can you tell me the problem with my AS/400 Model 9404. The display reads 11 2508 0B10 and the System Attention Light is on. Each Time I turn it on it stops at this point. The hard drives are running. Thank you. Rob

Answer Question   |  April 11, 2011  8:16 PM
AS/400 error messages, AS/400 errors, AS/400 Troubleshooting

AS400 – BRMS
I was saving all spool files using BRMS control group on a V4R5 system. Had an issue that the folder q1abrm was full. The job/BRMS was retrying to populate that folder for several hours. I exluded DEBUG and QEZJOBLOG outqs.  How can I resolve this?

Answer Question   |  April 12, 2011  5:32 PM
AS/400 BRMS, AS400 backups, BRMS, BRMS Backup

SQL server native webservices and PHP
Hi, I have a SQL server 2008 database and I need to query it from PHP running in a Linux box. I thought that using webservices was our best option. I am trying to use native HTTP SOAP in SQL server. Following some tutorials, I made first an SP USE [Basededatos] GO /****** Object: StoredProcedure [...]

Answer Question   |  May 10, 2013  12:34 PM
Apache, PHP, SQL Server, SQL Server 2008, WebServices

Upgrading from V5R3M0 to V5R4M0 Using HMC on P-570
I’m at the planning stage of this upgrade and it’s the first upgrade with a HMC attached. There’s no twinaxial console, so my question is , Can the HMC perform the upgrade? Do I need to attach a console, to carry out the upgrade.

Answer Question   |  April 13, 2011  10:06 AM
HMC, HMC updates, OS/400 Upgrades, V5R3M0, V5R4M0

Merging spool files to one PDF
Is there a way to merge 2 spoolfiles into 1 PDF file?

Answer Question   |  July 6, 2011  4:33 PM
AS/400 PDF, AS/400 Spool Files, PDF, Spool files

cvttostmf command
Where can I find this?

Answer Question   |  April 8, 2011  8:47 PM
iSeries Commands, spltool replacement, Spool files

User Auditing in V5R4
If i turn user auditing on for a Group profile,  will it audit all the ids in that group profile?

Answer Question   |  April 6, 2011  7:08 PM
AS/400 user administration, AS/400 user authority, Auditing, V5R4

Accessing abc.csv AS/400 files
how to access abc.csv files in as400.i have a abc.csv file,in this file have contain some data but i want to access into my physical file,with out using 3rd party tool.pls give advice

Answer Question   |  April 6, 2011  4:49 PM
AS/400, AS/400 CSV, CSV, CSV file format

Printer file in AS/400 subfile
[strong]Hi, I need to generate a separate spool file,I have 10 records displayed in subfile,if i enter option 6 in subfile,for five records,these five records should generate a separate spool file… each record separate spool file[/strong]

Answer Question   |  April 7, 2011  7:24 AM
AS/400 printing, AS/400 Spool Files, AS/400 Subfiles, Subfile