• water billing system

    does anyone know how to make a water billing system? im currently working on it for a project for my school and im stumped. i cant seem to make my prog run properly. please help me out, just a student here.. also, can you please send me a code on how to make my program run everytime i start my...

    Trebllaw0 pointsBadges:
  • WRKDBF replacement?

    Does anyone know of a good, free alternative to WRKDBF? I've been using it for years. However we just upgraded our business software. In this new version it has ISO date fields. For those fields that are null (essentially are 0001-01-01), WRKDBF can't handle it and blows up. I'm NOT a programmer by...

    Mrnaturl145 pointsBadges:
  • DSNTEP2 output problem

    DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don't have ANY experience with REXX, so an example would be appreciated. Jon

    Jonty Walker105 pointsBadges:
  • Access Oracle/Sybase/Informix from RPG

    Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse - my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should:...

    JohnDavid5 pointsBadges:
  • IT Data Updates and Auditors

    I would like to hear how other shops deal with auditors regarding data updates made by IT staff.   We use DFU/FILMNT/SQL for occasional data fixes. We print and file a log with who and why the change was made. Then to appease the auditors, we journal pretty much everything. A report is generated...

    LetItBe260 pointsBadges:
  • InfoPath cannot connect to data source

    Hi all, I have an InfoPath form in SharePoint 2007 that has dataconnections to SQL server DBs. I have a group of users that have been using them for the past few months with no problem. The permissions on the site have not changed but users can no longer access the Data connections. They get a...

    Jaylou185 pointsBadges:
  • how to store radio button responses in MySQL

    I am creating an online test. Each item has 5 response options (radio buttons with 1-5 values, or 5-1 values depending on the question). How do I store these values in a database, to be able to score the test later?

    Vm3335 pointsBadges:
  • pl/sql fixed file creation

    I am new to the pl/sql world. I'm ok with writing out a comma delimited file but I can't figure out how to write out a file where the fields are fixed length. I could use some examples. thanks,

    Bordenatemple5 pointsBadges:
  • export xml file of new stored data into a folder through trigger in sql server!

    Hello everyone , im newbie on SQL and need to make a trigger that generate an xml file of the new data whenever an action happens ( INSERT ), i looked around and found a clause that can query an output as xml format (FOR XML )but i cant make the actual (xml)file and put it in a path , can someone...

    Rahmony10 pointsBadges:
  • Latest date SQL

    Hi I am Trying to grab only the latest date from a uniquie stock number wich has mutiple dates? All i want to show is the lastest date against the stock number. Bear in mind that theese are comming from two different tables. Any Ideas

    Rizdon15 pointsBadges:
  • How to pass array in MySQL procedure parameter

    how to pass array in mysql procedure parameter

    Guptarun5 pointsBadges:
  • select parent where more than one child

    I want to select a row from the parent table based on whether there are two or more rows in a child table. What is the best way to do that?

    Ghjazz5 pointsBadges:
  • Get your FREE ITKnowledgeExchange.com sticker

    Be proud to show off you are part of the community with your free ITKnowledgeExchange.com sticker. All you have to do is answer a question and email me your handle and address and we will get one out in the mail to you. Allow 4-6 weeks delivery. Even if you have one already get one for your...

    ITKE371,720 pointsBadges:
  • Data type for output file in DB2 SQL

    I am using DB2 SQL on the mainframe - not sure of the version - I want to write out a file and transfer it down to the PC - how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as numeric and not character?

    Kath95675 pointsBadges:
  • Can anyone suggest a good loan APR formula in SQL

    I am getting a rather large error with an Excel RATE function, and so am wondering if someone can suggest a SQL formula or a solution?

    Nrate5 pointsBadges:
  • String Aggregate Function

    I need a report that provides an aggregate of a string column - in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish...

    Mgemmill5 pointsBadges:
  • SQL code made simpler

    I have 2 files that are clones - created by DUPOBJ. File_A is the original. File_BU is the copy. After I finish processing File_A, I want to update the same column (tSTAdm) in File_A when it is not equal to the same column (tStAdm) in File_BU. The file has a unique key – TsStat. I got the...

    PSMurray530 pointsBadges:
  • Oracle Inbound 850 Customer PO’s with Multiple Documents – Odd failure

    Ok, I know I might be sotgunning here, but so far I canna find even a glimmer of an answer to this. Oracle Apps 11.5.9 Oracle eCommerce Gateway Inbound EDI 850 Customer PO's I'm developing this process for a client, and I'm in the middle of testing my solution. Everything works fine when an 850...

    Jwhanon0 pointsBadges:
  • How to save the output from an SQL select statement to a spool file

    Please can someone tell me how I can save the output from an SQL select statement to a spool file. Thanks, Tom

    Tomotsk75 pointsBadges:
  • SELECT with LIMIT in AS/400

    Hi all, On my AS400, I need to select the first 90 records from one file and insert them into another file, but all the time i got all records in my result file. Is there any way to use the parameter LIMIT with my SQL SELECT INSERT INTO LIB1/FILE1 (FILE1) SELECT...

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