• AS400 ODCB table link

    When i link tables with a ODBC driver then some table won't give me any records (I link into microsoft access. But I do see the column headings. I the record fields I get: #Name? Is this an AS400 problem, ODCB or Access ?

    Davidfromnetherlands15 pointsBadges:
  • Problem with SSIS & AS400, Source is AS400, Dest is SQL2005

    When I'm trying to retrieve data from AS400, I received the below error: The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". How do I know which code page to use besides the default of 1252?

    Thuybui35 pointsBadges:
  • lCE

    what is level check error in AS400

    C.naveen09140 pointsBadges:
  • Error when executing RUNSQLSTM from CL program

    I am trying to use the RUNSQLSTM command. I get the error message "statement not allowed" Not really trying anything fancy. In CL program RUNSQLSTM SRCFILE(jwe/QCLSRC) SRCMBR(SQL1) + COMMIT(*NONE) In SQL1 I have SELECT mstid, SUBSTR(ftxref,1,1) AS ftxref_1, SUBSTR(HEX(SUBSTR(ftxref,2,7)),1,9) AS...

    Tcwalls5 pointsBadges:
  • HTTP Server Admin Instance

    We've i5 270 Machine with V5R4M0. When I tried to Start the HTTP Administration Admin Instance, The WRKACTJOB shows that Admin instance is starting, but few secound later Admin Instance Job ends. In the Spool of QTMHHTTP, QPJOBLOG says "Error occurred converting data. Reason 5." And Reason 5 is...

    huzaifa35 pointsBadges:
  • Remove exit point programs from the register without pgm names?

    We purchased a used AS/400. All the application programs were removed. We frequently receive a message, Exit Program not Processed. When I go to the register and select an exit point, there is no program or format listed. I am assuming the programs were delted when the application/user programs...

    zbbwoc95 pointsBadges:
  • Trigger program written in RPGLE

    I have a trigger program that have 3 files declared in F-Specs (no UsrOpn keyword).  Everytime it ends, it sets the LR indicator on.  Does the trigger program slow down processing when the trigger file is updated in a batch program?  Should I remove the code that turns on the LR indicator? ...

    bogeybetsy560 pointsBadges:
  • Load table in AS/400 database using Talend

    When i try to load a table in a AS400 database using talend 2.4.0, it given me an error like "There might be an error in SQL statement"

    Varunnt865 pointsBadges:
  • AS/400 FTP error- TCP3D2C Secure connection error, return code -24

    I am trying to FTP from Backup AS/400 box to our Production AS/400 box or visa versa and I get the following error when trying to transfer a file of any significant size(larger than 1Kb):

    ShawnPgmr60 pointsBadges:
  • PCSWS026 ERROR SAVING WORKSTATION CLIENT ACCESS

    I change the color mapping of AS/400.  When I close the session I get error message PCSWS026-Error saving the WorkStation Profile:L/ProgramFiles/IBM/ClientAccess/Emulator/Private/dsp6270.W.S.   Please note the slashes should be going the other direction.    Work station Program 5.8

    Trtap5 pointsBadges:
  • AS/400 Login Error

    I am tring with Hosname/IP both but it is showing 'Not able to login kindly reconnect'.

    AS400DB240020 pointsBadges:
  • Token Error in iSeries Navigator

    Help - what's wrong with my query: (Getting Token Error, From Into Clause) SELECT DISTINCT "T16.CPRP".CP_TOWNSHIP, "T16.CBL".CB_INTEREST_CITY MINUS ("T16.CBL".CB_TAXCOLL * .03) AS Interest, SUM ("T16.CTDT".TD_DETAIL_AMT_01) as Payments FROM QS36F."T16.CPRP" AS "T16.CPRP", QS36F."T16.CBL" AS...

    lorit365 pointsBadges:
  • Shake Client Access

    Anybody have a good idea on how to shake client access? I can do it in a web browser using javascript. But I want to shake client access screen. I could call some windows program if I knew of a windows program already out there that would shake the screen. I want to do this for a BIG TIME error....

    RonKoontz1,780 pointsBadges:
  • CHGPF error in Iseries v5r4

    The CHGPF command is giving error when used to change the CCSID from 37 to 285 in a pf in iseriee V5R4. The files are empty but it is showing the error as " Error occured during the update of physical file PFILEA in library LIBA using source file located in library LIBINST.."

    AS400TEC40 pointsBadges:
  • AS/400 errors

    One jobs is processing 2 Million records,due to some reason,it is in MSGW wait for decimal data error. In this scnerio,what are the actions we need to perform to reply the MSGW and remove the invalid data. ( suppose the output file doesn't journaled) Plz tell me the steps to recover on this.

    Samule400160 pointsBadges:
  • AS/400 SRC 000000E0

    This morning our old test AS/400 9402 was off. When we tried to IPL, we got the attention light on and an code 000000E.  Does someone knows what that error mean ? Any suggestion to revive that old thing ? Thanks in advance

    Briard25 pointsBadges:
  • AS/400 error message

    I am connecting AS400 through citrix application. I am getting the Error Code “E0001 – System Error” While trying to transfer file from AS400 to Host/ Host to AS400 Server. Please help me to solve this problem

    rajeshece1,215 pointsBadges:
  • AS 400 software problem

    Received the following in wrkprb should I contact IBM  Problem message ID  . . . . . . . :   CPI93B9                                  Severity  . . . . . . . . . . . . :   None                                     Problem...

    Karens6180 pointsBadges:
  • for AS/400 V5R2

    HI THIS IS BHAVESH I AM GETTING ERROR WHILE EXECUTING RDO PREPARED STATEMENT THROUGH VB6 ODBC CONECTIVITY ON AS/400 SERVER PL. NOTE THAT IT IS WHEN I HAVE CHANGED MY SERVER BOX FROM V4R5 TO V5R2 MODEL STRING FOR PREPARED STATEMENT I AM USING AS FOLLOWS Public SosRdoEnv As rdoEnvironment Public...

    Bu60 pointsBadges:
  • error while trying to login into my profile

    after typing my user id and password in the TN5250 emulator i get the following error Job 024527/QPADEV0006 started on 10/22/08 at 19:58:25 in subsystem QIN Message queue VANIS is allocated to another job. After that when i press enter i get another msg Job ended abnormally. Display the job log for...

    Jacky160 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