Unicode on AS/400 RPGLE

We are upgrading to 9.0 JD Edwards where the unicode tables have CCSID = 13488; I still need them to work with legacy files, CCSID = 37. How can I get these 2 types of tables to interact within RPGLE (V6R1M0).



Answer Question   |  June 27, 2012  7:34 AM
AS/400, CCSID, JDE, RPGLE, Unicode
asked by:
75 pts.

Opcode remove space in RPG/400 (RPGIII)

in RPG IV –> Trim in RPG III –> ? Ex  var1 length=10  var2 length=10 var1 = ‘AAA’ var2 = ‘BBB’ var1  cat  var2  —> ‘AAA       BBB       ‘    i want –> ‘AAABBB’



Answer Question   |  June 27, 2012  7:34 AM
AS/400, RPG READE Opcode, RPG/400
asked by:
AOM
45 pts.

Saving LF/PF to Tape

I’m trying to save the LF……but i’m not sure..so just tired in Google  but Couldn’t  get any  good result for saving a LF/PF to a tape.  Can any body explain me how to save Logical file and Physical files individually  to a  tape volume? like saving LF to MEDIA1 and saving PF to MEDIA2?



Answer Question   |  June 27, 2012  7:31 AM
AS/400, logical file and Physical File
asked by:
1,635 pts.

Binder Language

After updating Binder Language entry, do I need to use UPDSRVPGM command to update the binder lang correclty? Here I’m not using any signature for the Binder lang…



Answer Question   |  June 27, 2012  7:31 AM
AS/400
asked by:
Kar
425 pts.

exporting files

How can I move files into a Windows My document folder without having to use the export function? When I try dragging into the folder that I want it in, it become sa text file instead. Also, when using the export function it defaults every time to My Documents instead of changing the defauult to…



Answer Question   |  June 27, 2012  7:29 AM
AS400 admin, export file, Microsoft Windows, My Documents
asked by:
10 pts.

exporting files

How can I move files into a Windows My document folder without having to use the export function? When I try dragging into the folder that I want it in, it become sa text file instead. Also, when using the export function it defaults every time to My Documents instead of changing the defauult to…



Answer Question   |  June 27, 2012  7:29 AM
AS400 admin, export file, Microsoft Windows, My Documents
asked by:
10 pts.

Trigger over table that uses transaction inserts

I have a table that is being updated via JDBC. The program that is writing records (sql insert) is using transactions. This table has an after insert trigger on it. When the trigger is disabled the table is updates correctly. When the trigger is on we get the first record and the tigger locks the…



Answer Question   |  June 27, 2012  7:27 AM
iSeries, JDBC, SQL INSERT, Triggers
asked by:
KSC
90 pts.

I want to send a DB2 file via email from AS400 to MS outlook using MMAIL/SENDMIME command.

I want to send a DB2 file via email from AS400 to MS outlook.  I use command MMAIL/SENDMIMe inside my CL program. I’ve 2 issues. 1. whenever an email reaches to recipient, it attaches some .dat file which doesn’t have anything in it. 2. the attachment is in notepad, it removes the readability of columns.…



Answer Question   |  June 27, 2012  7:27 AM
AS/400 File Sharing, CL Program, Outlook
asked by:
70 pts.

Start Monitor from Command line

I would like to be able to start an iSeries Monitor from the command line. I have a program to check if the monitor is running and would like the program to start the monitor if not running. Found the information about the monitor in file QMGTC/QAYPSJDS.



Answer Question   |  June 27, 2012  7:24 AM
iSeries Access, iSeries administration, iSeries command line, QAYPSJDS, QMGTC, V5R4
asked by:
15 pts.

Shipment have insufficient allocations in BPCS

1 lines on this shipment have insufficient allocations. Can anyone please explain why this erroe comes during 12=Confirm for Shipment? And what is the alternative to remove this error message and confirm the Shipment? Many thanks in advance.



Answer Question   |  June 27, 2012  7:24 AM
BPCS, BPCS training
asked by:
5 pts.

How to know which program uses a particular module?

Consider I have a module, and I have made some change to the module, (not a parameter change, but just a logic change). Now I have to update all the programs which uses this module. Without the help of any external tools or APIs is there any AS400 command similar to DSPPGMREF which will let…



Answer Question   |  June 27, 2012  7:23 AM
AS/400, AS/400 commands
asked by:
1,880 pts.

How can i search spool files fast?

my user have so many spool files that are not been deleted. i was wondering if there is a way to search for a specific file or a different way for me to search? i only use the page up and down to see everything.



Answer Question   |  June 27, 2012  7:23 AM
AS/400 Reports
asked by:
360 pts.

Is it possible to track how the tcp routing entries got deleted?

Suddenly after one of my tcp ip interface went into recovery i found few tcpip routes missing. Is it possible to find from the Audit journals how the tcp routing entries got deleted, are they tracked in the audit logs?



Answer Question   |  June 27, 2012  7:22 AM
AS/400, audit journaling, iSeries
asked by:
1,160 pts.

Is it possible to track how the tcp routing entries got deleted?

Suddenly after one of my tcp ip interface went into recovery i found few tcpip routes missing. Is it possible to find from the Audit journals how the tcp routing entries got deleted, are they tracked in the audit logs?



Answer Question   |  June 27, 2012  7:22 AM
AS/400, audit journaling, iSeries
asked by:
1,160 pts.

Retrieving Subfile Size in RPGLE

Hi Is there any way for us to retrieve subfile size in RPGLE code instead of hard coding it by seeing from the display file. -Vivek



Answer Question   |  June 27, 2012  7:22 AM
RPG ILE, Subfile Size
asked by:
120 pts.

cleanup task

how can we find who have given the cleanup task?



Answer Question   |  June 27, 2012  7:17 AM
AS/400
asked by:
1,350 pts.

AS/400 query

I have one join file and one logical file. It is possible to create logical file on join logical file?



Answer Question   |  June 27, 2012  7:15 AM
AS/400 logical file, as400/DB2
asked by:
420 pts.

Can we do SFTP transfer of files between iseries and Windows.

Can we do SFTP transfer of files between iseries and Windows. Need the steps to configure the same.



Answer Question   |  June 27, 2012  7:14 AM
AS/400, SFTP
asked by:
1,160 pts.

Month names between 2 numeric Cymd format dates

hi, Hi, I have 2 Numeric field which has cymd date format Date1     7s 0 Date2      7s 0 date1  = 1110128    ( which is 2011-01-28    : January) date2 = 1120101  (which is 2012-01-01   ;January) So what i need is , I need to write records in a file , what are all the  months inbetween these…



Answer Question   |  June 27, 2012  7:14 AM
AS/400, RPGLE
asked by:
510 pts.

MQ Demo version

Hi… I have downloaded the MQ 7.0 demo version and after installing it, if I issue commands from windows command prompt, it is throwing error “Not authorized”. But I could able to do all activities from the mq explorer provided. Is is anything else that I should set so that I can give mq commands…



Answer Question   |  June 27, 2012  7:12 AM
MQ, MQ 7.0
asked by:
5 pts.