• Date calculation question

    I have a date manipulation question on the AS/400. I need to be able to take whatever date the system date is and calculate the next Friday date and output that to the LDA in the format MMDDYY. It needs to have the leading zero for the single digit months AND it is just a 2-digit year. I swear I...

    TomN50 pointsBadges:
  • Storing array values into an Access database table from a program

    Hi, I’m trying to write a program that stores the values in an array into a database table. The name of the database is Company.mdb and the table that I want to store values is called Employee. Below is the procedure that is supposed to perform the task. The problem is it doesn’t store the...

    Zigzagzig10 pointsBadges:
  • How to define two dimensional arrays in RPGILE

    I need to create an array that contains a code (2,0) and hrs worked (5,2) for that code. something like 01 2.3 4.3 5.6 7.0 8.0 02 5.0 6.0 7.0 7.0 6.5 I will then take this array and load a subfile to display on a screen. Thanks, John

    JAC260 pointsBadges:
  • Decipherig RPGLE Specs…

    I did a CPYF from LIBRARY/QRPGLESRC(RPGLEPGM) to a new physical file created on the fly. Now, I know that when you do this, the data in the SRCDTA field shows exactly what's in the program. BUT, how am I to figure out if an I-Spec statement reflects an actual I, IX, J, or JX prompt?

    Eric Witham690 pointsBadges:
  • How to save data back to databse from radio button? SQL Server 2005

    I am using 4 radio button, what so ever radio button I select, so how data revert back to database, I am doing this in asp.net 3.5 using sql server 2005

    Shaktilpu15 pointsBadges:
  • SQL Join on multiple columns?

    Can I join from one file to another on more than one column? For example, join from FileA to FileB on OrderNumber.A=OrderNumber.B AND ItemNumber.A=ItemNumber.B? All examples show only one column... I am on an AS400 using RPGLESQL, I need to join from one detail file to another detail file.

    Wlakesearcher100 pointsBadges:
  • Subtraction using Excel VBA

    Hi, I'm creating a sheet for the employees in my retail store. The spreadsheet has a column for the different items that I'm selling, and another column for the number of these items that I have in stock. Next to each of the item, I'd like to create a button. So here is my question: How do I assign...

    Curioussam25 pointsBadges:
  • Dreamweaver layout moves when in browser!

    Hello, I am pretty good at using dreamweaver, but one thing that happens when I preview in browser (I have tried both IExplore and chrome) what looks perfect when in edit mode in dreamweaver, then shifts in browser. I.e. the logo I have inserted is in perfect alignment and position, and when I...

    Sarahjaneshepherd5 pointsBadges:
  • How do I find the timestamp associated with HWM of processes/sessions in Oracle 10g on AIX

    The following SQL produces a very useful report of current resource utilization at the time of the query and the HWM since the database was started. What SQL can I add to list the time of the HWM? Database & ‘OS = Oracle 10.2.0.4 running on AIX 5.3.0.0 5300-09 64-bit. Thanks, Bruce col...

    Csybjf15 pointsBadges:
  • ucs2 data and bidirectional languages

    I have an application that has the data stored in ucs2 fields.  Moving the data from a ucs field to an alpha field works fine on our system.  On another system, when one line is in English the data is fine, the next line being hebrew seems to be performing a move instead of a movel no matter...

    anncyb80 pointsBadges:
  • Fetch element using getElementsByTagName excluding the namespace

    I have an XML code which fetches a node from one xml and creates a new xml out of it. the code is as follows,   parser = new DOMParser();  parser.parse(new StringReader(xml));  xmlSrcDoc = parser.getDocument();  xmldoc.setXmlVersion("1.0"); // new xml doc  xmldoc.setEncoding("UTF-8");...

    Tiro50 pointsBadges:
  • UNABLE TO CHANGE OR DELETE TEXT

    I have text that I created using m-text. I am trying to change it but it won't let me change it or even delete it. It is as if it's frozen into the screen. When I put the curser over it, it does not highlight it. I have never had this happen. What should I do?

    Kmrob5 pointsBadges:
  • Calling an RPG from a Win/Web application

    Hi, I look for a SSO solution. My customer wants to call a native RPG program (with displayfile) starting from a Graphical (Windows or browser) application without logon since the user is already signed in. All suggestions are welcome. thx Mathy

    MPaesen30 pointsBadges:
  • usage of QdtsChainSF

    Hi, I am trying to use the API QdtsChainSF with the prototype: d Chain Pr 10U 0 Extproc('QdtsChainSF') d SFLName 10A d pRcd * Value d len 10U 0 Value d rrn 10U 0 Value --------------------------- The call is as follows: c Eval Returncode = Chain(SFLName: - c %Addr(Record): %Size(Record): Looprrn)...

    Siri55 pointsBadges:
  • Locate J2SE PLUS SDK downloads

    I have been out of the job market for about six years. I am attempting to upgrade to 11i and earn certification. I have downloaded and installed 11g V2. When I try to bring up the SQL Developer I get a message to provide a path to jave.exe. When I do that, I receive a message that it cannot find...

    JoeBear10 pointsBadges:
  • AS/400 and Oracle Access Manager

    I have a strange behavior in an SQLRPGLE program accessing iSeries DB2 and Oracle via Oracle Access Manager. The program is very simple and reads values from two Oracle Tables in this way : a. SELECT .... into ..... FROM Table1 WHERE ..... return OK : 1 row as expected with my two fields filled. b....

    Technet30 pointsBadges:
  • SQL Command

    Hi friends (again), It's possible to prohibit a update option on a SQL Command to a guest user ?

    SILVARB440 pointsBadges:
  • DOT NET SQL CONNECTION TIME OUT PROBLEM

    IN MY SQL CONNECTION STRING I WAS MENTION CONNECTION TIME OUT IS 500. MY SQL PROCEDURE WAS RUNNING 45 SECONDS ONLY IN QUERY ANALYZER. ITS RUN ON DOT NET PROGRAM THEN CONNETION TIME OUT ERROR WAS COMMING.

    KonguKarna5 pointsBadges:
  • SDA1528 – VALUES graphic data format is invalid

    Hi, I am working in a project where unicode enablement is required for an existing application and i am facing following issues: 1. Existing Display files use COMP, VALUES keywords with character fields e.g. VALUES('ABC' 'XYZ' etc.) 2. CL programs are using Character variable for parameter...

    AMT45 pointsBadges:
  • I Put a HEX on youuuuuuuu……

    Does anyone have any suggestions as far as reference material that would help me understand EBCDIC Character sets, Hex, Binary, and how you can tie them into CL's & RPGLE's, and whatnot?

    Eric Witham690 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