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.

Problem on retrieve print queue information by API CPF3330 error

I got a problem during retrieve print queue information by API. The error message is “CPF3330 Necessary resource available”. Does any body have idea on it?   Thanks Sam      



Answer Question   |  June 27, 2012  7:11 AM
AS/400 print errors, AS/400 print jobs, AS/400 printing
asked by:
50 pts.

DB2 Web Query – Active Report Show Unreadbale Data

I have a report contains some information about customer name. When I save the output type as HTML ,the result is pretty good. The problem is, it is not good when save as Active Report AHTML. In each columns contains customer name in Thai will display as garbage or alian. How do we control this…



Answer Question   |  June 27, 2012  7:10 AM
DB2, DB2 query, DB2 Web Query
asked by:
20 pts.

Arithmetic Overflow when manipulating as400 data using vb.net 2008

I will include the code so you can see what I am talking about at the end. I have a vb.net 2008 app that I am writing. Everything seems to go fine until I add/edit/delete a record. I am getting the following error: Arithmetic Operation resulted in an overflow. If I ignore the error everything…



Answer Question   |  June 27, 2012  7:10 AM
AS/400, VB.NET, Visual Basic
asked by:
25 pts.

How to embed an image into RLU reports?

I have requirement to include an image (logo) into RLU edited report.I’m working on IBM 810 (V5R2M0) pls email to l.sugatadasa@gmail.com



Answer Question   |  June 27, 2012  7:06 AM
IBM 810, Report Layout Utility, RLU, RLU reports, V5R2
asked by:
5 pts.

Service program can be deleted after having a reference to the Service program?

I have a program which refer to a service program, now if the service program gets deleted,any impact? I know a module obj can be deleted after we create a program from that module as it is bind by copy. But since the service program is a bind by reference, will that delete cause any…



Answer Question   |  June 27, 2012  7:05 AM
Service program
asked by:
1,955 pts.

SQL connection failure error handling

Application group wants batch job to terminate if it is unable to establish SQL session to external database. Job log indicates MSGID QSQLMSG/SQ30080 “Communication error occurred during distributed database processing.   This appears in the joblog as a level 30 diagnostic message. When this message is encountered we want the job to exceed end severity and terminate.…



Answer Question   |  June 27, 2012  7:03 AM
Batch job, END SEVERITY, Joblogs, SQL connectivity, SQL Server
asked by:
25 pts.

iSeries Java Dump

I have a customer that is receiving a Java dump several times per day on their Test system but does not occur on the Production system. I know nothing about Java of the JDM. I can submit any part or all of the dump, but not sure what you would need. I am including the…



Answer Question   |  June 27, 2012  7:02 AM
AS/400 Dumps, iSeries, iSeries Java programming, Java, Java programming
asked by:
325 pts.

AS/400 login error when connecting to client VPN

Hi I coudlnt able to login in the AS400 server,as my client VPN got connected.it was throwing me the error..communication error occured.the error number was CWBLM0013.PC5250 license error.how can i solve this issue.please help me out. Thanks



Answer Question   |  June 27, 2012  6:59 AM
AS/400 Client Access, AS/400 login, AS400 license error, VPN
asked by:
335 pts.

Saving AS/400 Libraries on tape disk

Good day to all, I am new user of AS/400. I need to know how take backup of specific libraries on tape disk, step by step procedure, how to prerequisite services end and start after taking backup. Thanks, Regards, Tahir Ali



Answer Question   |  June 27, 2012  6:59 AM
AS/400 backup, AS/400 Library, Tape Backups, Tape libraries
asked by:
150 pts.

CWBLM0011 Error on V6R1

Hi,  We currently have 2 pc’s connected to a remote IBM AS400 via Client  Access V6R1. Recently one of the pc’s started giving the error “CWBLM0011 – An internal license error has occurred, rc=6211″. This happens with any user on that pc.  I have read various forums including multiple suggestions from itknowledgeexchange but all solutions…



Answer Question   |  June 27, 2012  6:59 AM
AS/400, Client Access, iSeries error messages, iSeries V6R1
asked by:
165 pts.

Network Issues Only Dropping PC5250 Sessions That Are Not Frequently Used

    We currently have a site that is occasionally having a network issue(PING commands shows connection verification stats of 2 of 5, 3 of 5, etc. or round trip speed in the 150 – 300 range instead of normal 50 – 80 range).     In this scenario User A uses the AS/400 all the time and doesn’t get dropped.  …



Answer Question   |  June 27, 2012  6:54 AM
AS/400, IBM PC5250 Emulator, iSeries Access, PC5250 Emulator, V5R3
asked by:
1,050 pts.

iSeries Navigator

I just installed Client Access 5.2 on a Win XP PC (I am successfully tunning this level on other PCs with the same OS) and whenever I try to print in Navigator, CWBUNNAV.EXE “encounters a problem” and brings down Navigator. I need help.



Answer Question   |  June 27, 2012  6:54 AM
Client Access, iNavigator, iSeries, iSeries Navigator, Windows XP
asked by:
10 pts.

ISeries Navigator

Hi, I am a DB2 DBA coming from zSeries to iseries. I have iSeries Navigator , when I click on “Database task”  “Map the database”nothing happens. Is there somewhere I can check for an error message or do I have to load an addon?     Regards   Wendy



Answer Question   |  June 27, 2012  6:54 AM
iSeries Navigator, OS/400
asked by:
95 pts.

Can I use SSL and DSMQ on the same Queue Manager

We communicate with two remote clients using separate channels over Websphere MQ for iSeries V5.3. Both are currently encrypted using DSMQ, but one client wants us to change to SSL. Can we use DSMQ and SSL on different channels on the same queue manager?



Answer Question   |  June 27, 2012  6:51 AM
DSMQ, MQ for iSeries, SSL, WebSphere MQ for iSeries
asked by:
5 pts.

Copy RACF dataset profile rules between LPARs

We have 5 lpars. I need to copy approx 100 dataset profile rules from one lpar to another. I’m fairly new to racf and not sure how to do this or of you can. Thanks.



Answer Question   |  June 27, 2012  6:50 AM
LPAR, RACF, Resource Access Control Facility
asked by:
5 pts.

Access IBM Tools

he there. I don’t know much about as400 client tools but I need their older versions for a deployment I busy working on. I We have a software delivery mechanism at our work place and have recently been asked to upgrade all older versions of as400/IBM client acces tools to the users. I have found…



Answer Question   |  June 27, 2012  6:50 AM
AS/400, IBM, iSeries Access
asked by:
5 pts.

RCVJRNE

we are using RCVJRNE with *TYPE2 for comparing the UB and UP entries to report the changed fields. We are using sequence number to match the the UB and UP entries. Now we are facing a problem Journal sequance number for entry Crossed length of 10 and we are getting journal entry number as  ”-1″…



Answer Question   |  June 27, 2012  6:48 AM
AS/400 journaling, Journaling, RCVJRNE
asked by:
105 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  6:48 AM
AS/400, RPGLE
asked by:
510 pts.