• Reformatting SQL Data in a Field

    Hi, I'm new to the whole SQL experience and need help converting some data.  In our Activity table, data was imported into the UF_4 field incorrectly.  We want to convert this data "from a Decimal format" to a “NonDecimal”.  Currently the data looks like 5234.000 and we want it to look like...

    DCDJ45 pointsBadges:
  • Export tabels from SQL Server to iSeries

    I have a need to export a table on an SQL server to a file on the iSeries. I would also like this to be automated so that when the table is populated, the information is automatically exported to the file on the iSeries. I have tried using DTS/Enterprise Manager, but to no avail. Any help would be...

    As400coder5 pointsBadges:
  • Changing Table with RUNSQLSTM

    I have a table that I need to increase in size. It was created using QDDLSRC and the RUNSQLSTM command. This table has a DDM file connected to it. Is the a CHANGE TABLE or REPLACE TABLE statement that I could replace the CREATE TABLE statement with so I can rerun the RUNSQLSTM and leave the DDM...

    Las Vegas Lopez5 pointsBadges:
  • USROPN file in SQLRPGLE

    I have a SQLRPGLe program. Certain files are not available at client terminal depending upon the applications purchased by client. I have a common program called from all applications and hence i user open the files based on the application types. my confusion is if i refer a file directly in SQL...

    Nutangujar895 pointsBadges:
  • AS400 File to MS Access by SQL Passthrough Query

    I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM...

    CompEng1,240 pointsBadges:
  • Tuning SQL query with hierarchy result through DB link

    I have the below SQL query: /********************************************************************************************************/ SELECT tm_super.tm_nbr ,tm_super.tm_fname ,tm_super.tm_lname ,tm_super.super_tm_nbr ,tm_super.super_fname ,tm_super.super_lname ,tm_super.super_job FROM (SELECT...

    Jlaksmana5 pointsBadges:
  • Display Bug with CFTextArea?

    Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query rows...

    PKS15 pointsBadges:
  • AS/400 SQL

    want to all some users to run an SQL for display only and not allow update of delete. is there a way to do this

    Cficik10 pointsBadges:
  • Crystal 8 & SQL problem

    I created 80+ reports for the company intranet and they worked great. At the time the ODBC's were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet...

    Virtualfrankdotcom20 pointsBadges:
  • Finding differences between 2 files using sql

    I am on V5R2 and am trying to find differences between a production file and an archived file using the following sql stmt: SELECT MAX(Filename), PORD, PLINE FROM (SELECT 'HPO' as Filename, PORD,PLINE from HPOL01 UNION ALL SELECT 'ARC' as Filename, PORD,PLINE from HPOARC) group by PORD, PLINE...

    Peeveeh45 pointsBadges:
  • SQL upload images problem

    hello glad to be here, i have a upload images tutoiral that i got from here http://geekswithblogs.net/dotNETvinz...n-asp.net.aspx but i can not get it to work, it is slightly tweaked for me. errors i am getting are: ------ Build started: Project: C:\WebSite4\, Configuration: Debug Any CPU ------...

    Zpupster65 pointsBadges:
  • Refresh/Run SQL

    We upgraded to Crystal Reports 2008. Our older version queries appear to work... In the Older Verion all we did is click the lightening blot. Now... we have to go through Database, SQL to run/refresh the query. Isn't there a one click key for to run these queries?

    CrazyCoder5 pointsBadges:
  • SQL select command

    Hi i hope all doing well, i have a problem with this SQL select command : **************************************************************** SELECT DISTINCT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price,...

    Abrahm7570 pointsBadges:
  • is varchar numeric

    sql to check varchar as numeric

    DuaneD5 pointsBadges:
  • Join Logical files and SQL views

    I hear Join Logical files are not supported in SQL DDL. But you have the SQL view instead. The shop I work for wants to use SQL DDL. But they have numerous interactive programs that use join logical files. If views cannot have keys, how on earth are they going to replace the join logical files in...

    bogeybetsy560 pointsBadges:
  • SQL Error

    we need to determine error message:the condition applied to this collectioncontains an ORDER BY without a corresponding TOP clause.

    RaqT5 pointsBadges:
  • Learning SQL Part 2

    Is there anything out there that would teach help me to learn SQL dealing with communicating with an AS400 system and using MS Access passthrough query system to bring it into Access but using the SQL system as the communicator? What books or Web sight is available?

    CompEng1,240 pointsBadges:
  • How to subtract positive number from negative number in an IF string

    Having trouble with knowing how to subtract positive from negative numbers in an IF formula. Also want to add a conditional formatting for all negative time in column H.

    WAT5 pointsBadges:
  • SQL: comparing rows and give the change

    saving greetings to everyone! i m receiving a dump data at day 1, inserting all that data into a database. this database has about 30 above tables, each and every table has about 100 above rows. every table has a column name cell id. on 2nd day i again receive the dump which also has to be inserted...

    K3820 pointsBadges:
  • Delete OLD files from Table not having date or timestamp

    Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

    RJES45 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