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
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
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
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
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
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
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
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
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
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
Can I put files in another library other than QS36F? And use the library list firstname.lastname@example.org Thanks
Answer Question | April 12, 2011 9:47 PM
AS/400 Library, Library List, S/36, S36E
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
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
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
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
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
Where can I find this?
Answer Question | April 8, 2011 8:47 PM
iSeries Commands, spltool replacement, Spool files
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
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
[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