• Text string gets SQL0406 via AS/400 RUNSQLSTM but works interactively

    I am doing an insert into a table and it works perfectly when run interactively on the iSeries but gets "SQL0406 229 Position 1 Conversion error on assignment to column BUDSPERSON". The field is Character, length 35.  The query is: insert into slsbudter ( SELECT ALLNUMS.BU, ALLNUMS.BUSUNIT,...

    randycoxclemson5 pointsBadges:
  • Excel add-in data transfer error CWBTF0012

    I'm having a data transfer issue. I get the CWBTF0012 general error. Looking it up it say reached max records. Here is the strange thing, I'm still under that number of records. According to what I have seen it relates to Excel 2007. I am currently using Excel 2010. I do have the client access...

    ToddN200022,610 pointsBadges:
  • Only one session can be used in Client Access

    In Client Access software, there are two sessions should be opened always. Once is the user session and another one is printer session. Is there any other way or software that only one session can be used? Why AS/400 session can not print documents in the default printer in the computer without a...

    Sureyz2,555 pointsBadges:
  • Problem with Client Access emulation with a telnet connection

    I try to connect from remote pc to i-series with client access, but it give me a cwbco1003 and a cwbco1048 error, but when i try to connect with tn5250j emulation all things go well why ? I need use the client access, thanks for help.Ps. that is the trace of the problem....

    Peppelan5 pointsBadges:
  • How to display files from a directory in RPGLE?

    I want to get a list of excel files and displayed them a subfille but for some reason it doesn't work. Here is the RPG code: MyDir = '/home/testdir '; dirh = opendir(%trimr(MyDir)); if (dirh = *null); p_errno = sys_errno(); Endif; What am I doing wrong? Please help!

    msn00745 pointsBadges:
  • Automatic AS/400 User Profile re-enable

    How do I re-enable an AS/400 User ID with a WATCH program? I would like it to change the password and set the new password to expire upom entry.

    HPW10 pointsBadges:
  • How to work with BPCS

    How can I do a project on BPCS?

    hyndavi5 pointsBadges:
  • AS/400 MIMIX, IFS objects present only on target

    My DG for IFS did not had OBJONTGT set as *delete due to which older logs that were automatically deleted on source were not deleted on target. I changed it to *delete but after that the objects and DB in error increased exponentially. The DG is in threshold that is why audit cannot run. Any...

    Ateeshsharma5 pointsBadges:
  • Online and batch program for CICS

    How do I determine hard code program for online and batch program for CICS?

    Shandilyan15 pointsBadges:
  • Is OVRDBF good to use for a query selection?

    Is OVRDBF good to use? I'm planning to query selection from a huge database file and then use OVRDBF. This job will be submitted multiple. Is this a good design in term of processing time?

    yeepiyaya160 pointsBadges:
  • AS/400: Display the programs who used a module

    There is a way to display the programs using some module in AS/400?

    Luissimon50 pointsBadges:
  • Problem when printing from AS400 (iSeries) to Canon imageRUNNER Advance C5255

    Hello everyone.  We have just installed a new Canon copier.  I created the Device Description and followed the IBM specifications for MFRTYPDMDL using *HPCOLORLJ.  My spooled reports keep going into pending status and I'm getting an error message stating that "an error was detected on the...

    hoppykins40 pointsBadges:
  • UPDATE SELECT Statement on AS/400

    I need to update over 700 rows in a file based on the values in another file.  I am trying to use the UPDATE SELECT statement on the AS/400 STRSQL command line but it keeps on updating all of the rows in the UPDATE statement (over 23,000 rows).  I need to learn how to successfully execute an...

    MSanford30 pointsBadges:
  • Subfile window (input) with regular screen (input)

    Is there a way to be able to enter information in a regular screen and in a window subfile at the same time? If yes how can it be done?

    msn00745 pointsBadges:
  • We set a PF to share(*yes) but when we do a DSPFD it shows a blank in the atshar field

    I created a file from the DSPFD command using the type of *basatr. when I query the file the atshar field is blank. However we use the DSPFD and display it and the ii shows *yes on the display. I'm not understanding the mismatch.

    chaze15 pointsBadges:
  • CPYTOIMPF From Spool File Garbage

    Hi. I'm trying to copy a report file from spooled output to a physical data file and from there to a stream file (as a .txt file) on the IFS. Once on the IFS, it's either sent out as a mail attachment via SNM by an MS Exchange Server or drag-drop'd to a desktop via iSeries Navigator. When the...

    Fireloque15 pointsBadges:
  • Setup remote printer Zebra model ZT420 wthin AS/400 CRTDEVPRT

    I have installed a thermal printer model Zebra ZT420 on my server AS400 with version system V6R1M1 I try to print a spool file generated for one applications within the server in IPL type, the printer displays the status "Ready for printing" i change the spool file to this out queue and the output...

    Rick2work5 pointsBadges:
  • Change standard width of Query Manager output printer file QPQXPRTF

    I need to change standard Query Manager output file width from 80 to 132. Is this possible in Query Manager. If so please let me know the procedure

    Anshan85 pointsBadges:
  • Records in subfile are put in another order

    We implemented an iSeries v7r1 over the weekend . In a particular display the user enters records in a subfile in last name order, when he/she pages down to another screen in the subfile the records change to a different order. The display, physical, logicals and programs have not been changed...

    JCunha70 pointsBadges:
  • Reading a Microsoft Word file (.doc) in a ILE RPG program

    I need to read the text of a MS Word file without opening word, reading it in a ILE RPG program, and put the text in a string. How can I do it? Thanks in advance.

    Alfredovitali5 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