• How to show sum of instead count(*) on ResultsetGraph of Maximo Start Center

    I have to create a Result set graph in Maximo Start Center that shows  sum of actual labor hours instead of showing count(*) on Y axis. for example, if siteid 'ABC'  has three workorders '1001','1002' and '1003' in workorder table with 3,2 and 4 actual labor hours respectively then I have to...

    Eknath15 pointsBadges:
  • SQL Select columns with columnized ntext data

    I have a table with 20 columns, where column 2 is an ntext, and it contains 133 comma separated 'fields'. How do I read the 19 columns and include in the output, the 133 columns from the ntext column.

    PeterGrierson45 pointsBadges:
  • SQL Option SQL option SRTSEQ=*LANGIDSHR

    I have PGM1 with SQL option SRTSEQ=*LANGIDSHR. Now from PGM1 I am calling PGM2 (PGM2 is a *PGM object with *InLR = *On) where SQL option SRTSEQ=*HEX When controls comes back to PGM1, what would be the SRTSEQ?

    BibekMajilla45 pointsBadges:
  • SQL Delete/Update

    I have file say with 100 records and I have 2 records which have similar data , so I have to delete only one record (out of 2 with same data) from the file, how would I do that? Every value in those records are same. I need solution through SQL statements.

    srav52025 pointsBadges:
  • Random generate in Access SQL

    If one random generate program on web, can it be hacked by a hacker and get the result?

    eessm13975 pointsBadges:
  • PCI compliance issue with SQL injection

    We're working on a client's PCI compliance. Here's one of the failing issues: 3.1.4. Blind SQL Injection (httpgenericscriptblindsqlinjection) We found out that the issue might be with the OWA. Does anyone know how to fix this issue?

    ITKE364,290 pointsBadges:
  • Converting from RPGLE to DB2/400 SQL

    My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

    SeaRancher5 pointsBadges:
  • Measure occurrences in MS Access SQL

    I was wondering whether it is possible (and if it is, the way) to perform the following task in Microsoft Access: there are two tables; first one consists of three columns 1) ID 2) tweet text and 3) date. Second table is a single vector of words, like a lexicon. For every row of the first table, I...

    dempar5 pointsBadges:
  • Date subtraction in embedded SQL

    I am trying to get all records with an order date in the past 30 days, but the database field is YYYYMMDD. I know how to do this in RPG, but I really want to do it in embedded SQL. Thanks!

    JeffWilson91320 pointsBadges:
  • Develop logic in Oracle SQL

    How to develop logic in Oracle SQL?

    saddammulla015 pointsBadges:
  • Where should I start my entry-level IT career?

    How do I start career in IT industry when I have got bachelor's degree a long time back. I do not have an experience in IT but in HR. I do not have an experience in Canada where I have migrated 9 months back. There are very few females in IT industry. Where should I start. I even thought of...

    rinkyyy35 pointsBadges:
  • ENCRYPT_AES return CCSID error

    Claude15 pointsBadges:
  • Converting the XML data into SQL table and how to move values to a CLOB variable.

    Can anybody explain with an example for converting the XML data into SQL table and how to move values to a CLOB variable. Because I've looked at lot of sites but still not getting a proper solution.

    Sasikumarr200 pointsBadges:
  • PLSQL code on iSeries

    Hi, I have a question as we have developed some plsql procedures on Db2 10.5 on windows & Linux. This is purely plsql code. as we need to run these procedures on all the databases under a particular instance. My requirement is can I use the same plsql code on Db2/400. I mean on iSeries. On...

    HABBIE860 pointsBadges:
  • Is SQL 2000 STD installed in Crystal Reports with an ISV?

    In Crystal Reports 9 is SQL 2000 STD installed with an ISV?

    kevin3215 pointsBadges:
  • Setting up a database server in-house

    Goal: add a database server for silo storage environment to meet client requirements. Send queried reports from shared SQL server to new database server to be accessed from website dashboards. What is the best server set up to accomplish this?

    SacredGrounds5 pointsBadges:
  • How to insert row number using SQL

    When importing data from Excel into MS Access, how do you insert a row number using SQL?

    JimStAubin201515 pointsBadges:
  • Find and Replace String

    How to find complete string e.g I have 2 strings in a file "TABLE" and "TABLE_NAME". I want to replace "TABLE" with "COLUMN" and "TABLE_NAME" with "TAB_NAME". My current script replaces "TABLE_NAME" with "COLUMN_NAME", which is not what I want.

    shrikantbothe25 pointsBadges:
  • AS/400 selective update with SQL

    Hi All, I am trying to create an SQL statement that will update many records based on a file containing fewer records. I can easily update ALL records in the primary file but I really only want to update those that need to be updated. In the item master file the cost has been changed for some...

    Ckelly0115 pointsBadges:
  • Non-Profit blues in affording a cloud base SQL that is HIPAA compliant

    We are a non-profit company that subcontracts to agencies that provides services to clients. These clients need to be certified for eligibility to receive these services every 6 months. Our funding source wants us to maintain some sort of system whereby the agencies updates each client as s/he...

    annstuart5 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