• Learning SQL Part 2

    Is there anything out there that would teach help me to learn SQL dealing with communicating with an AS400 system and using MS Access passthrough query system to bring it into Access but using the SQL system as the communicator? What books or Web sight is available?

    CompEng1,240 pointsBadges:
  • data base files

    How are the negative values in the packed fields are stored in the PF? How to enter negative data in those fields?

    ten20081,150 pointsBadges:
  • Automated backup of IFS to tape

    What command would I use to write an IFS file to tape and delete it on a daily basis?

    AS400 - Ask the Expert485 pointsBadges:
  • Sharing user profiles between AS/400 systems without overwriting

    I tried to restore system user profiles to another systems but have all the user profiles in *SAVF but I dont want the existing profiles in the system to over-write i tried to restore my id on the system but it got over-write can you please give me a solution how do i restore user profles without...

    AS400 - Ask the Expert485 pointsBadges:
  • how do I cancel printing of a user-open AS/400 print file?

    I'm on V6R1 and I have a printed report that I need to suppress if it contains no data. Currently it prints out a heading section and then a notice that '0 records were modified.' Unfortunately, the program logic behind the report is not simple enough for me just to do a record count and see if...

    Koohiisan5,030 pointsBadges:
  • Delete OLD files from Table not having date or timestamp

    Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

    RJES45 pointsBadges:
  • where to find correct source for XREF (as400)

    I located a series of as400 source for the tool XREF but is has a few missing references causing compile failures. References are: xreflib, MMenuoL4 and &LibLib. Please help.

    Gbssvcs5 pointsBadges:
  • Cursor position after EXFMT

    Hi all.I have a subfile over which a small window is shown.Both SFL and the window are shown simultaneously upon giving an i/p in SFLCTL.But the cursor has to be retained in the SFLCTL part after the SFL/WINDOW is displayed.If I write the window and EXFMT the SFLCTL,the window is not being...

    Eternal30 pointsBadges:
  • iSeries performance question

    Hello everybody, I'm trying to figure out the best way to count the number of records matching specified criteria in large PF. (The file has over 50 million records currently and with some purging we hope to bring it down to around 20 mil.) Anyway, I created the (SQL) view: create view largePF99 (...

    Dushan0 pointsBadges:
  • Changing Defaults QEZSNDMG Command

    Can you change the interupt user defaul to "Y" for program QEZSNDMG. Thanks

    RonKoontz1,780 pointsBadges:
  • Windows services connecting to iSeries

    Hi, We have an application which has an Authentication service running on a windows server and this service is connecting to the iSeries. In an unlikely event of iSeries not being available (eg if the backups are running longer than expected), the service tries to connect to iSeries and fails. This...

    Rockleadme385 pointsBadges:
  • HMC Details

    Dear All As we know we r using AS400 520 Server with OS V5r4mo .We wnt to Use Latest HMC ,which hmc will Best to use ,as we can install hmc application on windows pc, if yes than what will be he configuartion of wondows pc or its require additional hardware to do so ............,or we can get demo...

    Tabrezashaikh5 pointsBadges:
  • Types of reply codes in OS/400 QSYSOPR messages

    How many types of reply codes are there in OS/400? I can see the following: REPLY VALID RPY MSGDFT RPY SYSDFT RPY.

    navinnegi45 pointsBadges:
  • Certification sites for Synon?

    Hello, Please can anyone suggest some good certification sites or courses for Synon or DB2 400. Except the ones from IBM. Synon is more broadly needed!!

    Jammypune5 pointsBadges:
  • Backup other networked servers to internal iSeries LTO4 Drive

    Is anyone backing up other networked servers to their iSeries tape drive? How are you doing this and what software are you using. I would like to stay with IBM iSeries software if possible.

    Voodoovw1,735 pointsBadges:
  • AS400 Directories

    Is there a command that will let me know who created a certain directory in AS400?

    Jrmsn035 pointsBadges:
  • Moving AS/400 server

    Could you please explain how do I change the IP of an AS/400 box

    pwopen12245 pointsBadges:
  • Performance of iSeries network adapter?

    For a certain project requirement we have a connection(jobs running) between a windows server and an iSeries box and everyday at 6:00 am the jobs start between them, need to find out the network adapter's performance in specific. Is there a way to determine the performance of system and the network...

    harisudhan211,005 pointsBadges:
  • Can i able to see the source code if i have only OPM object.

    Hi All, Is there any way i can able to see the source code if i have only OPM object. I dont have source for my object. i want to see what are all the files that program is using and what are the parameters program is accepting. Regards, Mohan K

    Mohan K695 pointsBadges:

    Hi All.. suppose i want to access all records in wich any field begins with 'S' ... how can i do this in RPG ILE without using %subst Please help me.. Regards Ambrish

    Ambrish 82310 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.