Free SQL examples for V5R2

where can I find Free SQL examples for V5R2

Bob165215 pointsBadges:

AS/400 error

How do I solve error: message no. MCH3401 os ver. V5R2 ON SQL/400

Bu60 pointsBadges:

AS/400 data transfer from V5R2 to V4R3

Hi, how can I transfer data from AS/400 V5R2 to V4R3? Direct compatibility is not working.

Bu60 pointsBadges:

Security issues going from V5R2 to V5r4

we upgraded from V5R2 to V5r4 and now I am getting authority problems on any update programs in our custom programing library. User authorities were copied over. That seems fine. Were there any know security problems going from R2 to R4? I get around each instance by changing program to use Adopted...

Kroeter5 pointsBadges:

installing client access version V5R2M0 on windows 7 64 bit

Hi I was able to install V5R2M0 client access on windows 7 32 bit version but when I am trying to install it on 64 bit version then I am getting the error that XCOPYFILE-2 error. Could anyone please help me resolving out this error.   Thanks Vivek Sharma

VivekSharma120 pointsBadges:

IBM iSeries V5R2 and Windows 7

Does Windows 7 have any hope of working with IBM iaccess to this old operating system level V5r2?

AClemons5 pointsBadges:

What object is: CBLK41686645?

WHAT AS400 DAMAGED OBJECT IS: CBLK41686645?

YoungBobbyR5 pointsBadges:

Macro kill 5250 Emulator

When I run a macro, it kills the 5250 emulation window. The session is still run on the AS400 but the window in Client Access is gone.

Ssullivan5 pointsBadges:

CPYFRMIMPF CPF2845 reason code 10

OS/400 V5R2. I'm running a CPYFRMIMPF to import a file from the IFS drive to a database file. this is the command: CPYFRMIMPF FROMSTMF('/FTP/CPA/NUMERICT') TOFILE(ASPONITE/SCPA00_TMP) MBROPT(*REPLACE) RCDDLM(*CRLF) DTAFMT(*FIXED) STRDLM(*NONE) RMVBLANK(*NONE) FLDDFNFILE(ASPONITE/TBX400 SCPAFDF)...

Umpiredice15 pointsBadges:

iSeries source code recovery: SRC B9003E30

Hello there, We still have an old S10 system, on V5R2, for DEV users and unfortunately no more support. Now we have a damaged QSYS object, *SVRPGM, Q2CIO, that we cannot even execute a command. We tried doing an IPL but then we got SRC code B9003E30. Does anyone know how to recover from this code...

IS Questions115 pointsBadges:

Need help with setvar for iSeries query manager using not in ()

I have an issue with a Query Manager where I need help with the syntax for a list of entries in the Select not in ( ) portion. I have a command that will call an RPGLE module which will call the Query Manager. I know that the quotes have to be supplied by the calling program (found a lot of info in...

VGP300 pointsBadges:

Backup on V5R2 and Restore on V4R5

I have to Systems( one AS/400 running OS/400 V4R5 and An iSeries running i5/OS V5R2). Can I backup for example a file on the machine running V5R2 and restore on the one running V4R5?

RASHZENA0 pointsBadges:

Secure FTP

Please help me to set up Secure FTP for our AS400 iSeries-V5R2 machine to accept SFTP from Unix machine. Thanks. Luong Nguyen

Ncb5 pointsBadges:

Seeking Help with SQL SUBSTR Function using Host Variables in COBOL

Hello All I am currently on version V5R2 and I am trying to make a COBOL program produce some parsed fields from one large field. I have trying to use host variables for al three arguments in the SUBSTR function. The SQL compiler will take a host variable as argument number one but not for argument...

FCARPENTER200 pointsBadges:

Error after V5R2 Cum PTF load….

On Friday evening I loaded the latest Cum PTF's for V5R2. The box IPL'd without any problems and all the PTF's were "Temporarily applied". However, after a second IPL yesterday (scheduled weekly IPL) it failed and the screen SRC read B0006 1406. Has anyone any idea what this could be? The IBM...

Selectsoft65 pointsBadges:

System 890 Crash-Damaged File

We had a power outage at our server location and the UPS failed, thus our partition crashed. Once we were back up, we discovered a damaged object (a file in our production library). What is the best way for recovering (fixing) the file? We are on V5R2.

Suthor15 pointsBadges:

AS400 V5R2 RLU AFPDS Printer Files transfer to Excel

How can I take a printer file created in AS400 V5R2 RLU AFPDS Printer Files transfer to it to an Excel spread sheet?

Black Jack15 pointsBadges:

AS400 RLU AFPDS Printer File Transfer to Excel

We operate on a V5R2 release. IBM 9406 820 model. I want to transfer a RLU Printer File with AFPDS char to an excel spread sheet.

Black Jack15 pointsBadges:

AS/400 versions

I want to know about the details of naming system used for AS 400 versions like v5r4m1............,is it the new improved hardware or the operating system changes?

Anthappan5 pointsBadges:

Setting up Linux on AS/400 model 270

I have just added a new expansion 5075 to my AS/400 model 270 with One Processor, 6GB RAM, 6 DASD-17.5GB with V5R2 OS on it. I need to find out where I could find some useful information about how to setup Linux on this new expansion tower either as a new LPAR (Guest OS) or installing it on the...

ITKE1,132,240 pointsBadges: