Top Solutions

I am working with a Windows based server and an AS-400 datasource.  I am wanting to create a databse stored procedure on the 400 with which I can A) Pass in a series of approx 25k account #'s, B) Get necessary data for each of those acct#'s, then...

I am looking at virtualization to faciliate disaster recovery plan.  Along with many Windows servers, our organization has one iSeries AS400 server.  Can AS400 be loaded on a VMWare workstation box?

Hello, I am currently running Vista Business and trying to connect to an AS400 via my PC5250 emulator on my machine.  I've never had any trouble, even with Vista until a few weeks ago.  I hadn't updated anything or installed any new software, it...

Reason for: ?

Softwareproblemdaten für QTMFSRVR protokolliert
MSGID : :   CPI93B9
Programm  . . . . . . . . . . . :     QTMFSRVR
   Service-ID  . . . . . . . . . . :     9000
                  von Programm :   5761TC1
Symptomzeichenfolge...

I have an network printer set up on the iSeries that is constantly having the writer end.  It normally happens in the morning after the printer has been idle all night. A user will send a job to the printer, and instead of printing, the writer...

Hi,

I want a program in RPG/400 for Barcoding.  Please I need sample code for both read & write

Barcode.  Yes, separate Read barcode RPG & Write barcode programs is required.

I will give you the printer specification. I have two...

I am having a problem connecting to my 820 machine. I am getting CWBLM0031 RC1=2 and RC2=21. I checked the  Work with License Information but I am not sure what to look for. I was reading other posts and some say that I need "5722XE1base" and...

Hello,

I am having difficulty trying to get my head around something with regards to name resolution and PING.

In particular, I have an incorrect entry in the DNS Cache on the machine in question and ping seems to resolve the name to the...

I want to be able to change my library list. I know I can use edtlibl and change, add, or remove a library but how do I make the change permanent? I know there must be a default library list somewhere. Thank you.

Does anyone know how to fix the error, CWBLM0011, rc=6211?  PC is running is iseries access for windows, V5R4.  Thanks

I need to get a report of when users have logged on and off our AS400. Any thoughts on how to filter the DSPLOG or is that even the correct approach?

Hi

One of our users is getting an error message when trying to start a PC5250 emulator.
The error is:

PCSERR100 - Error Allocating xxxx bytes of memory from the Windows global memory heap.

No other programs are running at the time. The...

Hi everyone,

Kinda puzzled here, hoping for a little input and/or ideas.

Every month I run a query from VB on a file created monthly for the previous month's data.  Everything has been working fine up until this month, but something changed...

Hi I have a web application that uses a stored procedure to send an email.  I get the error message: "The client connection security context could not be impersonated. Attaching files require an integrated client login". Is there anyway I can...

Hi all,

I've got a problem on our company AS/400
We're using the 570 with OS version V5R3

The users are getting into the system through iSeries emulator(Telnet) and some web interface product
(ABL, Webface, etc)

Starting this 2 weeks...

Hi,

I was doing some maintenance on a DB2 COBOL program. The program has a very basic cursor which is used to fetch from a table. The OPEN is a basic one too (i.e. no additional parameters).  The FETCH command is executed such that it fetches...

I have to date fields stored as integers example 1080101 is equal to 01/01/2008 I need to see the difference in days
I am doing this in SQL inside iSeries navigator.
I already do some string manipulation to get the date into 'CCYY-MM-DD' format...

I have a client the is using ODBC to import/export shipping information from the UPS Worldship.  This has work for them for years, until recently we had to replace their AS400.  They went from a 170 V4R5 to another 170 V5R1.  Only the user...

Hello experts,

I have created a query in Query manager tool that lists some fields based on a date. This query will be run everyday and the date filter should be the current date. Someway I have to compare a date field in a table with the...

I have an excel add-in I created in Visual studio for office that calls a CL program on our as400. The .Net side of things works fine. The problem is the if the CL program has a problem and errors my excel Add-in does not know about it because...

I am taking a database class and the instructor wants us to download iSeries Navigator.

Where can I download this from?

Is this the equivalent to Microsoft SQL Management Studio?

Ok.  This situation has apparently been a long term one, but I'm trying to tackle it again since the user has been bringing it to my attention again.

Our iSeries (an 170, P05) is running v5R3.

The machine in question is running Windows XP. ...

I need to obtain the TOTAL disk space (ASP), USED space and FREE space on an AS400.

I just need the AS400 command and also how to enterpret the number displayed. For example, if the total disk space shows: 5000000 how do you convert that to MB...

Have two systems on our domain that are rebooting for no reason.  The event log is a mirror image on both of the pc's.  
Category 102
Event ID 1003

Error code 1000000a, parameter1 00000016, parameter2 0000001c, parameter3 00000000,...

What is the line command to vary on an AS400 device?

I need to generate syslog messages (for example every 15 minutes) and send them to a central syslog server. The information I would need are the one contained in  secured journal QAUDJRN:...

I have a user that recently complained of slow system performance. I removed PC-Doctor and all of the proprietary Lenovo software from his laptop. Then, I-Seires would not start. I opened control panel to remove it, and get a CA400RES.DLL dialog,...

I never created AS400 MENU, all the time i use the DSPF & CL for the any Menu. I have a need to create a MENU and call PGMS from menu
How ca i do that, what i have to do while complie, What type of file i have to comple?

I have a remote user who no longer can connect to our as400. He connected fine yesterday. Everyone else at his location can connect with no problem. He is running vista home premium. When he goes to connect he gets the error message:

pc5250...

Is there a way to setup a collection service and/or report that will provide object lock information for objects that generate contention errors?   We have a program that runs unattended that periodically encounters an allocation issue for a...

** note - couldn't put this in AS-400 OS at origination(it didn't show up), had to put in programming, then edit question to get option for OS, sorry if it clutters up the programming zone!

Looking for some documentation on ISeries v6r1...

I have a 9406-520 and I want to do a manual IPL, because nobody can access it. I also do not have a console. Can you please give me step by step instructions how to IPL from the control panel? Thanks!

I know how to map a drive on the AS400.  I have it set to reconnect at login.  But this week when I come in all the users connections are disconnected.  When I try to reconnect, it will not accept the user id and password.  THe user id is only...

Hi Experts,
I have been using the below mentioned code successfully to connect to Attachmate Extra. Using these definions i have been sending keys and extracting information into Attachmate Extra into Excel.
I am now struck with a requirement...

We are using an AS400 for some software and need to connect a Canon IR3235. I have been directed to try and find a PJL Driver to make this work. This article directs me not use PJL, but to use SNMP:...

Hi ,
We are running AS/400 V4R5 with BPCS 6.1. We had a system crash last thursday due to storage issue. All seemed well on Tuesday but a couple of BPCS programs do not complete correctly with error messages , the first of which is MCH3402 -...

I am using a AS400 and we had a power outage today.  The battery backup did not work (it was just changed a few months ago)so the system went totally down without an organized shutdown.  The system is a model 720 using OS400 4.5.0.  When the...

I'm trying to , using VBScript under PCOMM v 5.8, retrieve a record from the iSeries for a trailer number so I can get data out of a field containing the name of the *.PDF file I want to display.
I can scrape the trailer number from the screen,...

I just need to verify that I am seeing the total RAM on  my 400. In the screen print below, it shows all my memory pools. They all add up to the 4777 number at the top. does that number equate to:

4.6GB of RAM? did i calculate that correctly?...

I have a web application that uses iDB2 to connection the the AS400 (iSeries).  The connection works fine except that the library list isn't working.  

We have the following:

<add name="AS400" connectionString="DataSource=AS400;...

I came into the office early this morning and the power was off.  Apparently the power went out around 12:00AM, and it didn't come back on until around 6:00AM.  I went and checked on our IBM iSeries and it was hung during the IPL.  The SRC codes...

We are trying to connect UPS' Worldship (Version 10) to a database on an ISeries that contains all the relevant shipping informmation via an ODBC connection. The connection works fine except for two issues. Firstly, the initial connection take...

Hello Every One,
I have recently joined a bank as the Production support for their AS400 application written in RPGLE & S36
In My carrier I never worked as the production support, I am always being the programmer. Ok I will come to the point....

I need the iSeries command to display PTF CUM level patches installed and what my current PTF CUM name is. for example: C6255530 - Installed
C7198530  Current as of 07/09/2007

how to display that type of info on AS400. Thanks!

I have a user that has Folder in an IFS directory and he has permissions to that folder but he cannot open any file and or subfolder.  How can I change permissions on all the files within this folder without having to change each individual one? ...

I am having issues configuring correctly a Ricoh MP 6000 series printer scanner copier to print from the i-515. The users typically print from JD Edwards and use 39 to switch between printers.

Is there a default configuration that will work...

when logging onto an XP machine the error message the ordianl could not be located in the dynamic link library cwbcore.dll.  How can this error be corrected?

I am having problems witgh passing of variables to a CL program.  The variables are as follows

parm1 = '1'  (possible 11 long)
parm 2 = '070808' (possible 6 long)
parm3 = 'This is a test subject' (possible 60 long)
parm4 = 'Message 1"...

I have a few users getting an error using IBM AS/400 "invalid license error, rc=6211".  Users are on Windows XP and using Dell Latitude D620

i need a procedure for start/restart AS400 machine

I have to FTP few Files from as400 to PC and make some changes in that file in PC then up load to AS400,
How can I do this using basic FTP ?
I do not have the IBM client access.  Basicaly I have to use the ftp from command line.

Please tell...

I am configuring a tool that, at a particular point, executes a SQL statement on a DB.  It is that generic ... my SQL statement can be anything.

I need a SQL statement that will put the current date / time into a particular field of a DB2...

Hello,

I am working on some self learning on our iSeries. Trying to increase my SQL knowledge as well as other things. We have some LF (logical files) on the system and I am interested in dissecting them if this is possible. It has always been...

I am having problem to move file from my Production box to the Test box.  I created DDM file on my Test box and printing it to the QRPGLESRC in Production, I can copy new member to the Production without any problem.   But when I create a DDM...

Hi all,
        I'm developing a .net application that connect to as400's data queue and rpg programs via the cwbx.dll activeX provided by IBM iSeries Access and to a Oracle DB server via the Oracle .Net provider.
I have to compile my apps in...

When my users try to open word, excel files even attach documents to email messages from IBM IFS it takes forever. What I mean by forever when a user opens an excel file i can take up to 2min to open. I have tried this Microsoft Article 2570623...

Hi,

I am researching how to convert our native iSeries database to an iSeries SQL database (apparently there are great performance benefits to be had). As I've worked with MS SQL Server before, I know that in a SQL script on SQL Server I can...

I need an Excel VBA macro solution to down load a spread sheet to the iSeries (formally AS/400) and then to initiate an iSeries job to process the downloaded sheet.
I have already created a VBA macro that converts the data to .csv format and...

I need to delete a range of physical file members from a file in the AS400.  I know I can use clrpfm to clear one member at a time and cpyf to copy all members.  I want to split one file in two with some of the members in one file and the rest in...

Good morning everyone. I am baffled by an issue that started this week with no apparent cause. Everytime I send a spooled file to our WATER printer, it processes as usual, but then stays in a PRT status after the job has completed. You can't do...

Dear Sir,

Once again, i am facing the same problem while sending the Mail thru SNDDST command. AS400 Server and Mail Servers settings and parameters are okay as per my knowledge. I have enclosed a file containing the undelivery message. .
...

1) We have database schema in iseries AS/400 DB2 V5R3
2) On a insert statement we are getting error SQL0406 Conversion Error on assignment to column.
3) We know the column and same column DECIMAL(13,2) is in 2 tables. We are taking value from...

I have a user that attempts to run a query in Access from linked AS400 tables and receives the following error. ODBC--Call failed. I ran the same query from my computer and it worked fine. At her computer, I ran some of the querys that make up...

While trying to run a query against a linked AS/400 server in SQL Server 2005, I receive the following error:

Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.

I have narrowed the problem down...

I just took over an AS400.  I was called in after a power outage.  Everything seems to be working properly, except for print jobs.  Nothing will print.  I need some assistance with this.
When I enter:
VRYCFG CFGOBJ(HP2210) CFGTYPE(*DEV)...

How do I disable SSL Version 2.0 on V5R4 running with IBM HTTP Server?

I see that CALL QSYS/QSOMAINT PARM(35 1)

Will allow me to view the enabled/disabled SSL versions, but how do I disable a version I no longer want to support?
...

I have the cwbrxd service running on a Windows 2003 server.  I need to run RUNRMTCMD in batch mode to call a .bat file on a Windows 2003 server but am having trouble..  Specifics:

- .bat file is in a network share.  
- the path (from a...

I am trying to use the AS400 Data Transfer to Excel Add-in. The DTF file has the following SELECT statement:
SQLSelect=
Select=SHPREF,CLASS,POSTAGE,DATERCVD
Where=(DATERCVD BETWEEN 2010-01-01 AND 2010-01-31)

The file on the AS400 shows the...

I'd like to write a VB script in excel to establish a connection to AS400.
After I run below scrap to open the connection in myCon.Open,
popup windows arise for login and pwd.

1) Can I place the login & pwd into the myCon.Open option?
(I...

I need to check if the following ptfs are on our as/400. Could you please tell me how?

5722999     *BASE     Licensed Internal Code
 
5722SS1     1         OS/400 - Extended Base Support
 
5722SS1     12       OS/400 - Host Servers
 ...

Hi Expert, Is it possible to retrieive windows network id on AS/400?  Thank you for your time in advance.

Please give me AS/400 command about following questions.
Examples or any detailed explaination would be appriciated.

1. I know that the device name is the session name from the remote PC.
   How can I see the list of the device names which...

This is a really simple question, our brains our frozen and we can't come up with the answer...

We have a list of 50 files.

We've assigned them to a literal &P01 thru &P50, cut and pasted names in the values.

We want to perform a DSPOBJD...

I was recently hired into a AS/400 and windows server 2000 network enviroment. We currently use the IBM i series access program to access the AS/400 remotely. There are devices that are local to us on our network that the AS/400 can gain access...

I want to change the printer font on AS400 printouts. The OVRPRTF command has a FONT parameter.  Many values are shown in the drop-down.  Where do I find out the type of font?  And will this work to change the font for my printouts?

I created a nfs directory in rhel 5.1 which all of my other linux computers can see and use
when I make a mount on my as400 it mounts just fine.
I can see the mount dir and the first level of directories on the linux box but when I try to open...

I am a novice at SQL.  I am tried to insert records into AS400/DB2 file using a simple SQL statement but am getting duplicate records, even though I check if record/key already exists using the following statement:
insert into surveyor.CreatePN...

Hi,

We have a web application on Websphere 6.1 (running on a RedHat server), we wish to process the logon to the server initially using LDAP against an iSeries account, then once authenticated and session established on Websphere server - we...

I have enabled SSL encryption with a certificate. I setup the workstations to use the SSL option. This is the error I see when just trying to connect after typeing in my password.
CWBC0134-SSL errors, function returned 25406, %IPAddress%

with a CREATE TABLE in SQLRPGLE program should the field definitions be avaialble to the program at compile time.

On the AS400 you can issue the command "WRKQRY" and work with query definitions.  I have a lot of existing query definitions.  How can I quickly obtain or generate the equivalent sql for each query?  That is, as far as selecting, grouping,...

All,

I would like to mount a share that has been created on our Dell PowerVault 500 over a directory named /NAS that I have created in the iSeries IFS.  I have started the NFS server and verified the connection to the NAS from the iSeries...

Hello experts,  I am using the SSIS import and export wizard to migrate tables from our as400 data server to SQL server 2008 , the process fails.
as im new to the SSIS Im not sure where to start looking.
The wizard reports: [Source...

Hello,

    Is it possible to print out a last log in time and date for all user's on the AS400?

Dear All,
I am new to Synon
Please provide us the URL Address where i can gain knowledge  about SYNON
Regards,
Bsidmis

I have 7 fields in a subfile (one for each day of the week).  When I change any 3 or more of them to both from output only - the function keys quit working.  Change any two and all is good.  When 3 or more are changed I have to use system...

I have spoolfile with Polish character.
All is OK when I print it with *SCS printer device type.
But when I change for *AFPDS the Polish characters are wrong.

I need to automate the process for setting the connection properties in iseries Navigator.  I need to ensure that a host is set up for all users or at best the current user on a Windows OS that a specific connection exists and that it's IP is set...

I need to store a product code in English & a product description in Chinese on an AS400 database file.
I have the data on a spreadsheet & need to upload it to the AS400
I've created a physical file with a field defined with a data type of E...

I would like to print to my local laser printer connected to my pc from my as400 sessions. Does anyone have a walkthrough for creating the as400 printer and outq? Printer works from local apps on pc currently. e are use client access to connect...

I am having issues printing to a receipt printer attached to PC. Printer out put is generated on an AS400 and sent to the printer via remote outq.
When the remote outq  is started I see the spool file on the AS400 get sent.
Nothing will print...

Want to default to tray 2, not tray 1.
The print jobs go through but the printer asks to insert paper in tray 1, the manual tray.
Below is the Device Description
Device description . . . . . . . . :   HP4015  
Option . . . . . . . . . . . . ....

I'm looking for a CL program to give me the job# of an active job on my ISeries. I have two jobs that have the same name that I want to end but I need to know the job number to do this without intervention.  These are batch jobs that could have a...

We have an IBM System I with i5/OS V5R4.    We would like to do a file reorganization on the 100 largest files each month.     The problem I am having is trying to get the file information (filename, library, file size) into a file which I can...

Background: I was trying to end tcp on our test AS400 so I could add a new  SMTP email table entry.
I couldn't log into QCTL side on the Console Manager on the PC Console because someone had disabled the DST userid. So, I either used my...

I need to modify some records on a file that contains packed data.  I used STRDFU and followed instructions I found on the web to modify a normal file.  However, when I bring the file up and try to look at any record, it comes back with:

The...

I've a question regarding of my RPG program: a program that load all fields from logical file CVTC01L1, prompt indicated user to enter customer code located on top of screen, if user presses enter without entering any inputs, the program load all...

i have to execute cpytoimpf command from my java code ...can some1 tell me how to do that from java.my application is in as/400 only.should i use jt400.jar or something else.Plz Help