• Block Crystal Reports from iSeries access

    We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we can...

    WoodEngineer6,945 pointsBadges:
  • Trap SQLCODE from RUNSQLSTM

    I have a RUNSQLSTM that updates a table. When it hits a duplicate, it quits and returns SQL9010. What I want it to do is just skip the step that got a duplicate and move on. Is there a way to do this?

    khalon25 pointsBadges:
  • RPG: Determine which field changed in a file

    I need to get which field changed in a file, instead of writing multiple (IF this field changed THEN DO...) for each field in each file, I was wondering if I could use some tool in RPG for doing that?

    Luissimon50 pointsBadges:
  • How to retrieve all the records using CL program?

    How do I retrieve all the records using CL program?

    vishwaraj30 pointsBadges:
  • Turnover form IN-USE Status

    I was trying to promote a form over AS/400 turnover and my session got disconnected meanwhile. Its approved but not run yet. Due to the disconnection, I am not able to run the form now because the form is IN-USE status. What am I supposed to do now?

    yaazhisai225 pointsBadges:
  • 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...

    ToddN200019,635 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,525 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?

    yeepiyaya145 pointsBadges:
  • Merge two Physical Files using Logical File

    I have multiple Physical files (Trans2006, Trans2007, Trans2008, etc…) with same record layout with the yearly transactions on my iSeries. I want to merge these files (for temporary period). Is it possible to create a Logical file? If so please help me.

    nhewage50 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:

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