• Accessing Remote Databases from iSeries

    I am learning about how I can access a remote data bases from a iSeries to another iSeries. I can not use DDM files using SQL statements. Please, can you explain me how I can access databases from a iSeries to other iSeries using embedded RPGSQL? Regards and thanks for your help.

    Jeshua5 pointsBadges:
  • CPYFRMIMPF csv to PF – Encounter Data mapping error

    How to resolve the issue of using command CPYFRMIMPF to copy those records with blank date field in the csv file to be imported into PF?The date field in the csv file is '0000-00-00' and encounter error CPF5035 Data mapping error on member during the copy command and those records were ommitted.

    sjundesg5 pointsBadges:
  • Null dates coming in as 2001-01-01 SQLRPGLE

    Our SQL statement is literally trying to put '0001-01-01' into a field and it's still coming back as 2001-01-01... Any ideas?

    Dcantwell470 pointsBadges:
  • SSN ID format in AS/400

    Hi, I am new to this technology. I need to create some fields on Physical file which should accept the data in the format of SSN ID (123-456-789). Kindly let me know. How can I go with this? If this is an older question, please forgive me & post that older link. Thanks

    HABBIE820 pointsBadges:
  • iSeries Access Error when accessing a file in output queues

    When trying to access a particular file in Output Queues in System i Navigator gets error message "An unexpected error occurred. Check the system I Access Java Trace Log for additional information Exit Program denied request" How to fix this error?

    intripidfish5 pointsBadges:
  • How to keep whitespace in datagrid

    I have a simple .NET app. You key a SQL statement into a text box. It then connects to any one of 5 i-Series and returns a datagrid. I am curious as to how I can preserve the whitespace in the columns. These columns have some fields with data right and left justified. Other fields a large field...

    ToddN20009,905 pointsBadges:
  • SQLRPGLE program results nothing

    Hi,  I am new to SQLRPGLE. I have coded something, which finally shows nothing.Please have a look on my code & kindly help me to get the output. This is my program         *************** Beginning of data ************************************ 0001.00 HDEBUG(*YES)                  ...

    HABBIE820 pointsBadges:
  • CPYF Command in AS/400

    Hi, I have two files (A,B) with different definitions (Column names,data type,length etc) are different. Both are on same AS/400 system. Now I want to copy all the records from FILEA to FILEB. What I want to say is, COPY data from one file to another file, where nothing is common in between them....

    HABBIE820 pointsBadges:
  • QMQRY ERROR

    Hi, I am new to this technology. I coded some CL program with QMQRY. every thing goes well. Object has created. If I run manually using STRQMQRY. I can view my expected result. If I run Through a CL program , I was facing some error. Please go through the be-lowed program & its corresponding...

    HABBIE820 pointsBadges:
  • iSeries Catalog Tables

    Hi, What are the privileges required to access all the Catalog tables as (SYSCOLUMNS,SYSCST,SYSFUNCS,SYSCST,SYSKEYS,SYSPROCS,SYSTRIGGERS,SYSVIEWS) from STRSQL.

    HABBIE820 pointsBadges:
  • Looking for an iSeries service provider

    Hi, I am looking for a iSeries service provider in & around USA (not a German server). Could anyone please let me now some vendors so that I can contact them. Thanks!

    HABBIE820 pointsBadges:
  • Restore object to iSeries/AS400 IFS

    How do I Restore an object (folder) to the iSeries IFS from our nightly backup SAV command, under a different folder name.

    aniguf5 pointsBadges:
  • Unable to ping iSeries server

    Hi all I am unable to ping my iSeries server from 5250 emulator. I was using it last day and properly power down it and today when I came and try to connect it from 5250 emulator it just refused to come up. Although it is working perfectly with the terminal attached to it. I also have searched this...

    hunshabbir71,165 pointsBadges:
  • Save physical file too small in AS/400

    I would save a PF (800G with about 3 billion records) and one of its logical file. OS is v6r1. However it said the save file is too small. I remember that this limitation of save file is 2T while the size of my physical file and logical file no more than 1 T. Anyone can help me? Thanks a lot.

    liushiqiang15 pointsBadges:
  • Redirect to an externally hosted payment page from iSeries

    In a legacy (iSeries) order management system, I want to replace inline payment screen with a redirect to externally hosted payment page in an effort to support external tokenization. What are my options?

    bijoykp35 pointsBadges:
  • iSeries share folder cannot be connected

    My user has a network driver connected to iSeries share folder. Everything works fine at the beginning until user changes her password in iSeries. Then, the network driver was disconnected. Password was not saved at the time of mapping the network driver. We are using Windows 7 with V6R1M0. This...

    minidora5 pointsBadges:
  • How to insert a trademark character (™) in iSeries

    How to insert a trademark character (™) in iSeries? It is not registered trademark. ® , it is trademark (™) which I need to insert and I'm unable to do. Could you please help?

    NicyChn110 pointsBadges:
  • Status SELW and hanging there

    The status SELW in iSeries is just hanging there. What do I do about this?

    edewing20 pointsBadges:
  • IBM iSeries access for Windows

    How I can exponentiation in SQL of IBM iSeries access? I need execute a financial formula and it's include exponentiation.

    guille271141015 pointsBadges:
  • Calling MS Server from iSeries Stored Procedure

    Hi, I have an ODBC linked server connecting MS SQL Server to my iSeries. What products (other than Java), if any, would I need to be able to call a MS SQL Server Stored Procedure from an iSeries Stored Procedure?

    JeffreyStark5 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