• Converting a varchar to a numberic in SQL query

    How can we convert a varchar field to Numberic in a SQL Query in db2 400?

    AS400 - Ask the Expert485 pointsBadges:
  • Vary on failed for TCP/IP

    We have an iSeries 270 with seemed to have lost TCPIP communication. The TCPIP interface info comes up with status 'inactive' when started. I have tried recreating the line controller with information from IBM but still says 'TCPIP vary on failed.

    AP25 pointsBadges:
  • AS400 DSPUSRPRF

    I ran this command DSPUSRPRF and I was wondering if anyone knows where I can find the meaning for each column heading. I ended up with 69 headings. I can figure out some of them, but I wanted to know if there was a comprehensive list for all output headings.

    Vparras5 pointsBadges:
  • FTP messages

    When ftp'ing from System i to an internal network pc, what is the difference between the messages "Cannot find host", and "Cannot connect to host"?

    Sf368675 pointsBadges:
  • Tools for example unit test source RPG

    I need tool for test code. any proposals ???

    RPG19825 pointsBadges:
  • How can i position the cursor at the beginning of the input field?

    Program a calls pgm b that displays a window, with first input field an unsigned numeric, length 3. Screen is compiled with *rstdsp = yes. Control passes to pgm c then back to b. On return to b, the cursor is always at the 3rd position in the input field as it was before going to program c. How can...

    LLoyd02445 pointsBadges:
  • AS/400: Unique records in file

    hi all, i have a problem , suppose i have a physical file which has multiple occurrences of fld1 , now i need to access that in distinct (one data single time) order. so i created a logical file with UNIQUE keyword . but when i make query on this LF then msg comes that no member found. and a dump...

    Ambrish 82310 pointsBadges:
  • I have a ZM400 and want to upload some templates to the pinter memory can some one help me out

    I have a ZM400 and want to upload some templates to the pinter memory can some one help me out

    Ery5 pointsBadges:
  • Duplicated Files

    Hi friends, I have a System (AS/400) and on this server i have many and many files with the same name , example: I have the file FILEX on LIB1, FILEX on LIB2, FILEX on LIB3 , etc ..... I Run the command DSPOBJD OBJ(*ALL/*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE) OUTFILE(LIBTEST/FILETEST). Now, How can I...

    SILVARB440 pointsBadges:
  • create a remote outq which points to an outq on the remote iSeries

    i need to transfer spool files from one iseries server to a remote iseries server.

    Fukuyi5 pointsBadges:
  • Sorting data in RPGLE

    How to sort data in rpgle program countrywise in program coding only?

    6r1,520 pointsBadges:
  • Symbols on Zebra 170Xill

    Can the zebra print medical device label symbol for manufacturer?

    Jpatak10 pointsBadges:
  • Data Area in CL?

    How to get data from Data Area using CL program code?

    6r1,520 pointsBadges:
  • AS400 mapped drive locks Windows account

    I have a user that has AS400 mapped drives. When they access the drive, their Windows account gets disabled!?!? This isn't happening to anyone else. We use EIM to control access to the Netserver folders. He can access the AS400 folders just fine, but when he does, that's it for his Windows account....

    ScottWHI25 pointsBadges:
  • AS400 read of PC files

    On the AS400/ISeries/SystemI, I would like to read PC file data from a PC Server into my RPG program. What is the best way to accomplish this task? Right now, it would be for READ ONLY.

    Danljonessr10 pointsBadges:
  • How do you parse xml in COBOL when the message has repeating nodes

    The Documentation I've seen around COBOL XML parsing only speaks to single instances of a given node. What is the technique when the message has repeating (Unbounded) nodes for example: <Address> <Name></Name> <Name></Name> <Name></Name> ........

    HankSumner5 pointsBadges:
  • protect_lines backarrow drags protected text down into editable area

    I have used CL_GUI_TEXTEDIT class to create a custom control for text entry. I am using the PROTECT_LINES method to afix a date/time stamp and then make it non-editable. The problem is, when I am in the editable area and I hit back-arrow until the cursor jumps up to the end of the protected...

    Ratherbjammin10 pointsBadges:
  • Fold/Drop

    I have a dds in which the subfile record spans several lines of the map. I need to display the first three lines and truncate the rest using a function key to display the rest. Truncation occurs after one line when using fold/drop. Is there anyway to change where there truncation takes place?

    Schue10 pointsBadges:
  • as400 Menus

    How does one query on the as400/IBM menus that exist.

    Mramos110 pointsBadges:
  • How do I convert a Unix text file from IFS to a DB file on AS400?

    I've got a flat text file that I want to convert from AS400 IFS to a Database file. First I want to convert to a flat file just to prove I can. The File is being Sent via FTP from Unix to AS400/IFS. Files have been sent in both unix txt format and MDOS format. Both files can be displayed on IFS no...

    slack4002,705 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following