• as400 sql – non numeric data in numeric field

    is there a function I can use to avoid and abend when sql hits a numeric field that contains non-numeric data. sql: select * from LPDtst/ARCOMB WHERE ACAOF# <0 Error: Selection error involving field ACAOF#.

    oldpgmr75 pointsBadges:
  • On the as/400 i series can one use SQL querys to update file

    Cobol uses some kind od IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the code would like. How would the updated file be...

    nitzinger385 pointsBadges:
  • Retrieve data from Oracle9i to SQL server

    Currently my database client using SQL Server 2005 and there have another database whereby is using Oracle 9i, I wanted to retrieve the data from the oracle whereby query in SQL server 2005. 

    Xue8715 pointsBadges:
  • String Field Comparisons

    I am attempting to create a formula in Crystal Reports That will compare two string fields and print out an ID number. It seems as though it should be quite simple. Please help.

    DonnaBailey10 pointsBadges:
  • MIRA to AR interface question

    How does the carrier bill date affect the detail bill date when an account is coded in the AS400/Iseries? In other words, if a carrier bill date is erroneously placed on an account prior to coding being done, what happens to the detail bill date when the record is interfaced from the MIRA to AR...

    Notanittech5 pointsBadges:
  • SQL to insert comma-delimited string value to table column

    I have string like '1,2,3,45,6,7,8' I want to insert each comma separated value in a table column...my output look like this: COLUMN 1 2 3 45 6 7 8

    231219835 pointsBadges:
  • Magento block and reference, problem with showing block in Magento phtml

    Hi, I am stuck with following issue. I want show product_viewed block (recently viewed products - magento block) at specific position on my front page (templates/page/mylayout.phtml). Look at code snippets of page.xml, catalog.xml and mylayout.phtml Header and footer and other magento blocks are...

    MichalDrozd15 pointsBadges:
  • Compiling under V5R3 for V5R4 usage

    Dear, I'm trying to modify a small CL to comply with new functionalities of V5R4. This CL is used mainly to send datas when the iSeries is on Restricted State, so I've to restart the TCP. Before I was using the command STRTCP STRSVR(*NO) STRIFC(*NO) but with the V5R4, I have to use this command...

    PierreLG45 pointsBadges:
  • In RPG program

    Hi, In RPG program i declared files. One for reading and another for Updating. Both the files are in different Library lists. How do i achieve this???? Thanks in Advance Rama krishna

    0 pointsBadges:
  • QSYSOPR Break Mode Problem

    When i change my qsysopr delivery mode to *break mode.it it is breaking for all the messages like (mess needing replay and mess not nedding a replay).By this we are not able to concentrate on MESS NEEDING REPLAY.When ever new alert (mess not nedding a replay) came it is over riting earlier one....

    qmaster1,675 pointsBadges:
  • Testing latest Virus Definitions

    How to ensure that our AV software can handle the latest Virus defination. Is there any global repositories where these viruses are defined and which can be used for Testing?[o:p][/o:p]

    Mayurkhe295 pointsBadges:
  • iSeries Token Error

    Need help with this query - it will not run token error.  Here is the query: SELECT   SUM  ("T16.CTDT".TD_DETAIL_AMT_01 * .10) AS TOTAL, "T16.CPRP".CP_DISTRICT_CODE

    lorit365 pointsBadges:
  • REXX

    I need to read a file having a name of the dataset. And then have to check whether it is cataloged or not. Can anyone let me know how to do it? Thanks for the information

    Aksofashish5 pointsBadges:
  • Avoid duplicate entry in database through VB

    I have made a program in VB with Access as back end.  In the data base there are three fields which are unique id of a person.  I want to display "Already Exist" message box when i enter an already existing id. matching all three fields and not allow duplicate entry.

    Adwaith100 pointsBadges:
  • como visualizar el contenido de esta pagina

    como puedo visualizar esta direccion [/ p] http://192.168.1.65/ara/busqueda.php [/ a] [/ p]

    Rhernandezb5 pointsBadges:
  • How to find the processes linked to a service

    On a Server I look after a Trend-Micro service was stuck in the stopping state. As I couldn't stop/start it even from the command prompt I figured that it must be waiting on something else before it can stop. I closed Trend and this didn''t make a difference; I checked all the running processes and...

    OwenAmbrose1,930 pointsBadges:
  • GAMBAS – as front-end of open dbase?

    hi..greetings to all i am an IT student and i am here to seek help. I am using UNIX OS. edubuntu v9 to be specific. and we ar eought to make a databe having gambas(if your familira wiht it) as front and dbase as the physical storage..how is this possible. last year we created a mini-database using...

    Cookie726315 pointsBadges:
  • To increase my knowledge abt web technologies like asp.net

    hello sir, Currently I m geting involved in one project, actually it is not a project just doing it for myself or to increase my knowledge. the project is portofolio management sevice.In this you can get ur current market worth bot all ur invesment thru this s/w. I have collected some info., but I...

    Citiusaltius4tius60 pointsBadges:
  • Troubleshooting OWA

    I have just configured a Windows SBS with RPC over HTTPS for Outlook access. You then configure Outlook client to use RPC over HTTPS to access the server. However, when I test Outlook from outside the company network, you get the error ‘There is no response from Outlook server’. I am very sure...

    EST15 pointsBadges:
  • VB.NET CLIENT/SERVER APPLICATION

    Can anybody help me, I'm wanting to create a client/server application in Visual Basic.NET to provide a network administrator with a remote enquiry tool (NetAdminSystem). The NetAdminSys tool should consist of two programs: the NetAdminSys server that is running on a remote computer (that acts as a...

    Genius260 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