updating char in Oracle 10g
To update a CHAR column: <pre>UPDATE your_table SET your_char_column = ‘X’ WHERE …; </pre> If that’s not what you mean, please provide more details.

View Answer   |  January 5, 2010  1:59 PM
Oracle 10g, Oracle Statements, UPDATE statement

Problems eliminating HEX 41 character.
Hi You can do this by creating a character conversion table and then specifying it on the FTP command: a) Get a copy of the QASCII (EBCDIC to ASCII) conversion table by using the RTVTBLSRC command: RTVTBLSRC TBL(QASCII) SRCFILE(my_lib/QTXTSRC) SRCMBR(MYQASCII) b) Use SEU (or WDSC) to edit the MYQASCII source member you just created. Line [...]

View Answer   |  January 4, 2010  7:32 AM
Application development, AS/400, DB2 Universal Database, RPG, RPGLE

Merging of files in AS400
The merging of files is done by using the CPYF (Copy File) command and specifying the *ADD option to append the data from one file to another: CPYF FROMFILE(A) TOFILE(B) MBROPT(*ADD) FMTOPT(xxx) The FMTOPT parameter tells the system how to do the copy, for example: FMTOPT(*NOCHK) means copy left to right, character by character. FMTOPT(*MAP) [...]

View Answer   |  January 3, 2010  10:39 AM
DB2 Universal Database, RPG, RPGLE

Oppurinities in IT field
Get yourself on linkedin.com and get your social network up! You’ll need some knowledge of service delivery management, ISOs etc. It may be worth doing a short course on service delivery management, but they’re not hugely expensive. In my opinion, it’s a good thing that you have a good technical background, because at least you’ll [...]

View Answer   |  December 30, 2009  7:23 PM
Careers, CCNA, IT careers, ITIL, Networking, Networking careers

which is the best course in networking
It depends on what you want to do. Network+ is a good start. Certs are the only thing though so don’t spend too much time/effort on getting certified. Here are some <a href=”http://www.principlelogic.com/careers.html” title=”networking career”>better ways to get more preference on your resume</a>. +++++++++++++++++++++++++ CCNA/CCNP and MCSE/MCSA are the main certs which Employers look for… [...]

View Answer   |  December 30, 2009  7:08 PM
Careers, IT careers, Networking careers, Networking certifications, Networking training

AS/400 Query Join
Generally your Primary file is the one with the fewest records. If you have multiple records in any of the files and you only want selected ones from those files, then you need Select/Omit criteria on those specific files.

View Answer   |  December 29, 2009  5:03 PM
AS/400 Query, JOIN statement

SQL RRN Processing – by Key?
select * from table where rrn(table) between 2500 and 5000 I’m not positive how efficient that is, or if it is/can be indexed, so, finding some key to use may be more efficient, but, I have used rrn() quite a bit in the past. when I needed to limit results. If you’re using different RRN() [...]

View Answer   |  December 29, 2009  10:43 AM
DB2 Universal Database, RPGLE

FTP from iSeries DB2 to iSeries AIX (Oracle)
One possible cause, You are FTPing in binary mode so no character set conversion takes place. If your i5 has CCSID = 65535 (the default) then once on the AIX LPAR, the data is binary, not character. If your file is in CCSID 65535, you need to specify the character set conversion in the CPYTOIMPF [...]

View Answer   |  December 29, 2009  5:18 AM
Application development, AS/400, DB2 Universal Database

AS400 intreface with other platforms
The best option for you is to Uninstall and install and Configure the platform your interfacing AS400 to. that has worked for me in the past. It will depend on what model AS400 server your attempting to access. =================================================== The discussions below should be taken as the answer. The answer text above has essentially nothing [...]

View Answer   |  December 29, 2009  4:13 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, Security, Web development

How many rows will a FETCH statement return in an explicit cursor operation?
It should return a single now each time you run the FETCH. ——- MUTI-ROW FETCH can (and will ) return more than one row Steve —————-

View Answer   |  December 28, 2009  8:41 PM
Cursor operation, Explicit cursors, FETCH statement

Database concepts
Stricly speaking, a ‘database’ is a collection of information. The information stored on this web site could be considered a database. So could a bunch of tape files. Today, when one hears ‘database’ one tends to think of ‘relational database management system’ and this cause some confusion because a ‘relational database management system’ (RDBMS) implies [...]

View Answer   |  December 28, 2009  2:55 PM
Database, Database administration

Using two same files from different libraries in a RPGLE program.
Even though more info is needed to guide you, these hints may be of some help to you: 1. Use SQL in your proces. 2. look into the two system files that contains info on files and fields. Run these two Query-commands and you will get a peep into the files: RUNQRY *N QADBXREF and [...]

View Answer   |  December 28, 2009  6:00 AM
CLP, DB2 Universal Database, RPGLE

Is it possible to reorganize a very big transaction in one night?
Unfortunately there is nothing you can do about the RGZPFM command locking the file. Is it possible to reorganize the file only on a weekend where you might have a larger amount of time for it to finish? One other thing you might want to check. Do a DSPFD on the file and see if [...]

View Answer   |  December 28, 2009  3:53 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security

SYNON vs COBOL
Good morning, I’m not a SYNON expert but from COBOL there is something you must see: COBOL creates an executable package does not need the environment for running, ?does SYNON the same?. In COBOL all variables are predefined and allocated during the compilation time. ?Does SYNON the same?. A COBOL program is almost 80% pure [...]

View Answer   |  December 25, 2009  4:19 AM
Application development, AS/400, CLP, DB2 Universal Database, Development, RPG, RPGLE

Optical storage
This is what we use to copy a Physical File to a share on the network. The file ends up being comma separated CPYTOIMPF FROMFILE(library/filename) TOSTMF(‘QNTCservenameshared folder’) STMFCODPAG(*PCASCII) RCDDLM(*CRLF) The correct STMFCODPAG is what makes if PC Readable. Maybe you can modify this to go to DVD. ============================================================ CPYTOSTMF seems a better choice than CPYTOIMPF. [...]

View Answer   |  December 25, 2009  12:12 AM
Application development, AS/400, Backup & recovery, DataCenter, DB2 Universal Database

MS Access Report modifications
You should be able to just select the label – not the field. Then hit the delete key. –msi77– On the Layout roll-up you can use Delete Template icon to disconnect label. Maybe I mistake in names, so I use located version in other language.

View Answer   |  December 22, 2009  4:42 PM
Access 2007, Access reports, Microsoft Access

convert from msaccess to sql2005
You could use the <a href=”http://msdn.microsoft.com/en-us/library/ms187928.aspx”>CONVERT</a> function to format dates (although it could be more efficient to do that on the front-end), and the ‘+’ operator to concatenate strings.

View Answer   |  December 22, 2009  3:34 PM
Microsoft Access, Query Manager, SQL 2005

Need suggestion about the selection of field in telecom.
No one can tell you what the best certification, degree, or line of work is. You’re going to have to figure out what you’re interested in and what you want to become an expert at. A couple of hours in the bookstore/library or perusing titles at Amazon.com should help. Here are some <a href=”http://www.principlelogic.com/careers.html” title=”IT [...]

View Answer   |  December 22, 2009  3:20 PM
Careers, IT careers, Telecom, Telecom Careers

SAP and AS/400
Don’t even look back SAP pays like 10 times as much. For everything about rpg.

View Answer   |  December 22, 2009  2:22 PM
AS/400 careers, Careers, IT careers, SAP careers

Pipe Delimited CSV File
As I remember it. there was a difference between the AS/400 | vertical bar and the ASCII pipe. We used to cut the pipe from an ASCII document and paste it into the 400 application (that was back when computers were made of stone). Don’t know if that would help. Phil ————————————————————————————————————————- You may be [...]

View Answer   |  December 22, 2009  1:33 PM
CL Commands, CL programming, CSV, CSV file format, File conversion programs, File formats, File Transfer Protocols