• Help in CL and RPG

    Hi, I can execute a CL command in an RPG pgm by calling 'QCMDEXC'. But there are certain CL commands that i cannot execute using 'QCMDEXE', what are they? Thanks in Advance Rama krishna

    0 pointsBadges:
  • Error in a Group of Called Programs

    Hi, I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC.......so on...10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this???...

    0 pointsBadges:
  • Use Dynamic Create Table Command in Stored procedure

    Does any one know how to pass a library and table name variable to the SQL CREATE TABLE Command? I need to be able to build the tables on the fly and the name needs to be different each time the table is created. I am calling the SQL Command from within a Stored Procedure. Thanks

    FCARPENTER200 pointsBadges:
  • Upload to AS400 DB file

    Hi I am not so proficient in programming and i am looking for a way to upload an excel sheet into a database file (with same columns as in m excel) on the as400. I tried to FTP, but i goes in as a flat file. Various other FTP options using FDF etc have failed. Any suggestions ? Thanks Raman

    Dashingraman15 pointsBadges:
  • Reading a Save File

    I have automated a process that does the following Collects objects to be FTp's to a remote system Builds a save file of these objects and FTP's them to a remote AS/400 I would like to automate the receive side to restore the objects with little or no intervention. What I need to do is read the...

    Johnd0155 pointsBadges:
  • media recovery

    Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

    Sukaina10 pointsBadges:
  • Connecting Samba to Active Directory

    Afternoon all, I am having trouble trying to get a samba file server to work correctly under Active Directory(Windows 2003). I have gotten the linux PC to connect to the AD network, join it and uthenticate on it. However when I get the server to browse to the linux PC, I get prompted or a username...

    Nephi10 pointsBadges:
  • Connecting Samba to Active Directory

    Afternoon all, I am having trouble trying to get a samba file server to work correctly under Active Directory(Windows 2003). I have gotten the linux PC to connect to the AD network, join it and uthenticate on it. However when I get the server to browse to the linux PC, I get prompted or a username...

    Nephi10 pointsBadges:
  • Device stops at midnight

    I am using a 232SDA12 which is a data acquistion device from B&B Electronics. I am using the following VB code and for some reason it stops at midnight. What am I missing? '***************************************************************** ' File name: 232SDAXX.BAS ' Version: 2.00 ' Release Date:...

    Kfink040 pointsBadges:
  • AS400 PRINTER FONTS

    I have been asked to produce new printed output in the Helvetica style. I have looked high and low for the font codes to plug into the CRTPRTF cmd with no sucess. Where can I find a listing of these 2, 3 & 4 byte codes (ie 18, 82) We don't have printed documentation on site, and I seem to be...

    MONDOU0 pointsBadges:
  • E-mails not going to proper folder

    I have a folder that is setup in Public folders call Internship. This folder should be receiving e-mails external, but we have not been getting them for awhile, it has work in the past, for the last month or so we have not got any e-mails to that folder. My users are telling me that people have...

    Margaret Rouse3,040 pointsBadges:
  • stored procedure

    When I write an external RPGLE stored procedure that returns a result set does not return anything although it seems to return something when I debug it. Something seems to be missing because when I return an array it works fine. What am I doing wrong? Below is a piece of my code EVAL SQ='SELECT...

    GTseli5 pointsBadges:
  • Subfile not displaying properly

    I am having a problem with my subfile not displaying properly. I my application, I have two scrollable subfiles displayed. The user can select several vendors and then display a list of checks sent to that vendor in a sequential manor (meaning if the user presses enter, the next vendor selected?s...

    RickSavoy0 pointsBadges:
  • Sorting out missing out

    I have 2 files. One having 1000 records and the other 1350. I need to sort out the missing records and place them in an excel sheet. Programmatically how to acgieve this???

    0 pointsBadges:
  • Trying to publish a Webfacing Project

    Using WebSphere Development Studio I've created a WebFacing project converted an existing application on our iSeries to a WebFaced application, but i can only access the WebFaced application from my PC. How publish the application to a web server so that other users can access it. I tried exporting...

    Slaliberte5 pointsBadges:
  • How to reconciliate two development systems in one Production ?

    Hello, We are upgrading a classical SAP Landscape (Development, Quality Assurance, Production) from 4.6c to ECC6.0. The problem is that, in parallel, a separate HR project is taking starting to enable payroll on a separate development system. The standard landscape must remain untouched untill end...

    Fortmah0 pointsBadges:
  • Call a stored procedure with output parameters

    Good Morning, I have created an oracle stored procedure which has 2 input parameters of type date and 1 output parameter of type PL/SQL table. I recieve errors when I try to execute the stored procedure in SQL*Plus. The stored procedure exists in a package and the Oracle database version is 10g. I...

    IYAN230 pointsBadges:
  • ASP .NET SQL Statement

    Thanks to SheldonLinker my earlier question has been answered. I continue to have 1 issuse and it is with my conditional SQL statement. I'm thinking someone will be able to correct this very easily. Here's the statement: If ("SELECT DataID FROM table1") = UserID Then Update Else Insert End If I...

    Wolfman240 pointsBadges:
  • Updating one record with a field of another record where two other fields match

    I have the following Table: XREF Group Projid id1 id2 ----- -------- ----- ----------- AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG...

    Donnewbee0 pointsBadges:
  • SQL – IF Exists Update Else Insert

    I have searched far and wide but have not been able to solve this problem. I am still in the early learning stage and this is the most complex issue I've come across so far. I have a form that when submitted needs to either update fields in a table or insert new records. I originally created a form...

    Wolfman240 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