• Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB

    I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done this?

    Minidach15 pointsBadges:
  • subfile in RPGLE

    i have indicator to show fields in a row red in subfile... when i select some option say 5 - view against this row, it displays necessary details. now affter dispalying this when i return back to existing screen, i update SFL to make the selected option 5 blank, and redisplay the file.....however...

    Nutangujar895 pointsBadges:
  • what is SEQONLY(*YES) property

    [strong]Hi,                                                                                                                                       i have a problem...

    Sreeraj20 pointsBadges:
  • RPG Programming Standards

    I'M LOOKING FOR RPG PROGRAMMING STANDARDS. We have always had standards example if you create a report the report should have the date, title, program name, page numbers.  Does anyone have a stanards document or is there anything on the web?   I appreciate your help!    

    Superbusy15 pointsBadges:
  • display file – window RPGLE

    I have a window for a display file       whenevr i display field level err message the message appears outside the window.... how will i get it inside the window at the bottom? @depnum        11Y 4B 11 18 A 41                                 ...

    Nutangujar895 pointsBadges:
  • DB2 indexes and Crystal Reports

    Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?

    AJ525 pointsBadges:
  • Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?

    I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? I'm assuming there...

    Srichfdic20 pointsBadges:
  • SQL query error: token DATA

    I am new to Db2 on iSeries. I am running some SQL script files using JDBC to create a repository on DB2 for my project. The query is of the form: Create table tbl_name(col1 datatype(size),...... ,coln datatype(size)) DATA CAPTURE NONE; I am getting error on token DATA.. I tried to execute this...

    AS400 - Ask the Expert485 pointsBadges:
  • How do i see when a job was created in the wrkjobscde area

    Morning I need to urgently find out when a job was created in my job scheduler. Thanks

    Justin88330 pointsBadges:
  • Contest Update: Nominate a member and you could win 1 of 5 Amazon gift cards

    A quick and important update on our Panasonic flatscreen contest and the nominations process -- we will be giving away five (5) $20 Amazon.com gift cards at random to members who nominate someone in the community feedback form here. Thanks!

    ITKE827,900 pointsBadges:
  • AS/400 service program

    i want to use service programs and binding directory concept in my program, i know it theoritically, that is i aksed about it. please let me know the process how to use it

    Hemavijay85 pointsBadges:
  • Email attachments from Domino Server to IFS share?

    Can an agent extract email attachments from a user's mailbox, and move them to an IFS folder on another iSeries (AS400) box without notes cline running?  We have a generic email account that receives email attachments, but there are no Notes Clients that will be watching it, so this agent would...

    Hdwest61120 pointsBadges:
  • 5250 job initiation

    Can anyone remember how to start a job (e.g. and enquiry) on a 5250 workstation either from another session, releasing that session, or from a submitted job.   I have used ACQ and REL in the dim distant past but cannot member  if this is possible.

    Eskdale5 pointsBadges:
  • AS/400 Authorization List

    Is there is any way to secure an object via more that one authorization list? If it is, then what is the use of adding more than one autl to the single object?

    Lsivabe85 pointsBadges:
  • Printing On a Copier/Printer

    OK. I have tried everything. We have envelopes that are 12 1/2 by 9 1/2. I generated a spool file with all the data I want on it. B/c of the size we have to put them in the manaul tray. When I do this it will not use the Page rotation. I tired going to drawer 1 and no rotation. Then I tried *E1....

    RonKoontz1,780 pointsBadges:
  • AS/400 ASP%

    what is the default ASP% in AS/400 and what is the procedure to define our own.

    now225 pointsBadges:
  • Problem when printing from AS400 (iSeries) to Canon irc1021

    Hi everyone, We have changed one of our HP-printers to a Canon iRC1021 but does not work when sending a spool file from our AS400  just one line of =#*?&% characters is printed. Does anyone has a clue about this problem and how to get it work? Greatfull for all help. Thanks/Stefan

    STCA60 pointsBadges:
  • The most-watched IT questions this week: Sept. 22, 2009

    Curious as to what the most popular IT questions and answers are on  ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.

    Michael Morisy8,598 pointsBadges:
  • System Upgrade Path Software and Hardware

    We have a 170 box running V5R1.  Which upgrade path is doable and or the best. Upgrade 170 with V5R1 to 270 running V5R2 Upgrade 170 with V5R1 to 270 running V5R4 Upgrade 170 with V5R1 to 525 LPAR running V5R4     

    28390015 pointsBadges:
  • Record Lock in Subfile

    Hi all, I am trying to find any keyword which is used to lock the record in Subfile. Please find the scenario: Let assume two users are trying to read the same record on the subfile from different session. Now when the 2nd user was trying to read any record while 1st user is using same record...

    vipin2m55 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.

Thanks! We'll email you when relevant content is added and updated.

Following