Use of CCSID in AS/400?

What is the use of CCSID in AS/400 Physical File? How it is important? What are the considered/configured to be noted when we develop web application in AS/400 with native DB2 database?

Sureyz2,825 pointsBadges:

AS/400 display program message

I am seeing this message from a lot of my users when they try and access the routing application within the AS/400. It has 4 options to answer the message but none seem to do anything. The exact wording is" Job 408069/ED/QPADEV0160 started pm 7/25/16 at 08:46:10 in subsystem QINTER Message queue Ed...

whaline5 pointsBadges:

RPGLE validation

How can I do a validation like first 3 words character and next 5 must be number in RPGLE?

Vishalsuryavanshi15 pointsBadges:

Converting Float to packed

I am trying to convert a Float8 to a 17 6 Packed and I am loosing 1/100000th of the value of the decimal portion. The packed result is 1/100000th less than the Float value. How do I stop this from happening? I am calculating taxes.

Kcgto4550 pointsBadges:

iSeries sending emails to a group

We would like to emails sent from the iSeries to a group when a job that runs at midnight unattended has an error message. How do we set this up?

bwb1011115 pointsBadges:

How DB2 converts the FLOAT value to IEEE floating-point format?

I had created a SQL table as below: CREATE TABLE MYLIB/Mytable (FLD1 FLOAT (9) NOT NULL WITH DEFAULT) When I ran DSPFFD, I had seen that FLOAT(9) gets converted to 3F 2. So, I want to understand how does it happen? Which algorithm is being used?

manojibmi5 pointsBadges:

How to get nth highest salary using SQL/400 query

Hi, How can I get nth highest salary from a PF named EMP having two columns EMPID and ESAL need to retrieve nth highest salary using SQL/400 query. Here N may be first, second,third any no.  Thanks!

6r1,975 pointsBadges:

AS/400: How to check the list of source libraries inside a library?

In AS/400, how do I check the list of source libraries inside a library?

Ruchik15 pointsBadges:

Passing parms to Query400

Has anyone ever come across a method of passing a parm into a query run - such as a date?

Abbey120 pointsBadges:

If an account has \’Initial Program\’ =*NONE and \’Initial Menu\’=*SIGNOFF, the parameter \’Limited Capabilities\’ is not relevant. The account cannot be us

If an account has 'Initial Program' =*NONE and 'Initial Menu'=*SIGNOFF, the parameter 'Limited Capabilities' is not relevant. The account cannot be used on the command line. Is this true? What about if user is restricted to only one program? Could you elaborate on Initial menu and initial program,...

aldc123100 pointsBadges:

Code for BI Publisher template

In BI publisher, report should be populate in long name, for that I need code to insert in template RTF.

zyngapoker5 pointsBadges:

Removing a Window without Re-Displaying the Underlying Record Format

Program TST040 displays format Fm01Fmt. When the user presses F8 program TST041 is called, which displays a window and immediately returns to TST040 to continue processing (denoted by the Sleep function). After the “processing” completes, Fm01Fmt is redisplayed, removing the window from TST041....

wbellis335 pointsBadges:

Where can I get an INFOPRINT 300dpi AFP print driver?

I'm new to AFP and need to get set up with the proper AFP driver. I need the Generic INFOPRINT 300dpi AFP driver. Do you have a link I could try? Thank you.

cher20165 pointsBadges:

The installation image can not locate any language resources

The installation image can not locate any language resources. What can I do?

JimTanaka400005 pointsBadges:

System i Navigator Error

Good day, whenever I try to open System i Navigator I receive an error message, "cwbunnav.exe - Application Error". The application was unable to start correctly (0x000020c). Any help would be greatly appreciated.

tjnixon5 pointsBadges:

Like in SQLRPGLE

Hi, I am using the below query in SQLRPGLE Select count(data) into :cntrec from sample where data like '%' "+:tpnumber+" '%'. I am getting an error "Token "+:tpnmber+" was not valid" . The tpnumber is a character field(10a). Sample file is a flat file I even tried '%' +:tpnumber+" '%' and '%'...

Prashanth123270 pointsBadges:

Dynamic SQL in RPGLE

How can I build a dynamic SQL statement for input from a screen file?

davidgrant10 pointsBadges:

Uploading .CSV spread sheet to AS/400

When saving an excel spread sheet to .CSV, the numbers in the columns will look like this 1E+13 no matter how I format the file.

UARTJ175 pointsBadges:

How can I find to what program my iSeries Module was bound?

I am trying to clean up a system (new contract) worst control of source that I have ever seen, buy I digress. My question is, If I have a module object on the iSeries, how do I find what program the module was bound?

SicRob5 pointsBadges:

Turn off AS/400 notification

At the bottom of the screen it says: The cursor is on row 3 column 23. Input is not inhibited. Insert mode is off Caps lock is off. 3270 numeric lock is off. How do I get rid of this?

babydoll15 pointsBadges: