• SQL/400: Call CL program

    From stored procedure in SQL/400, I want to call the CL program. I have created the wrapper program for calling CL as SQL procedure.(qcmd). How can I pass the param with quotes to CL program? SBMJOB CMD(CALL PGM(abc) PARM('parm1' +'parm2 'prtn1')) JOB(prt1) + USER(braha1)

    Bhusha40 pointsBadges:
  • [SQL0029] INTO clause missing from embedded statement.

    HI, I have written lots of RPG/ILE & CL & COBOL programs in iSeries. I never worked on procedures & UDF. Now I'm learning these. I'm trying to create a procedure. This is the code. It's compiled without any errors. While running I got the below error. CREATE FUNCTION SUS.REWT(p_value...

    HABBIE895 pointsBadges:
  • Is there a problem with my file server and SQL or the operating system?

    Hello good day, I have a LAN with star topology-tree. (Internet dedicated, 1 router, 2 servers, 1 switch, 1 AP, 40 PCs) OS Windows Server SBS 2003 and PCs with Windows 7 and 8. The network cards in the servers are 1GB, Router 1GB, 1GB switch PCs 100MB. Cat5e cabling. But the data transfer is very,...

    JASAvtek5 pointsBadges:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 pointsBadges:
  • How to get local time of a SQL server?

    Hwo to get local time of a SQL server and store it in a variable of a client program written in C#?

    Edchu5 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:
  • Using Decode in oracle sql query for Debtors Analysis Report

    i have a table called transactions in my oracle database which stores data for employees under particular employers. each member has an account and employer_id with transactions , the table has fields as below. TRAN_ID, TRANTYPE_ID, PENSION_ACCOUNT, EMPLOYER_ID, TRANAMT, SALARY, TAXEDAMOUNT,...

    wiri5 pointsBadges:
  • SQL0204 error for LPAD

    Hi I am trying to LPAD in STRSQL and getting below error. Type LPAD N * in * LIBL not found. Same SQL is running successfully on another server. Can anyone help me on this?

    BibekMajilla70 pointsBadges:
  • IF…THEN for a SQL SELECT statement

    How do I do an IF...THEN for a SQL SELECT statement? So I have this already: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product How can I do it?

    ITKE366,925 pointsBadges:
  • SQL Convert Legacy Integer Date to actual date for Comparison issue

    I have a PF with a date broken in to three fields: 4 digit year, month, and day. I'm converting it in my SQL statement as follows: DATE(year||'-'||month||'-'||day) This works great for valid dates! The problem is there are invalid dates in the file such as 2/29(non leap year),30,31 or 4/31. There's...

    Dcantwell475 pointsBadges:
  • SQL: Conditional used in where clause

    In SQL, what are the conditional used in where clause?

    veronicahmungai20 pointsBadges:
  • Ignoring fields in SQL Where Statement

    Can fields in a where statment be ingnored. Such as Where name = :name and date = :date, but if I just pass in a name I'd like the where to select only on the name and ignore the date.

    Charrdzc5 pointsBadges:
  • How to validate user parameters in Oracle Reports 6i?

    Hi! I am using Oracle reports 6i to modify a standard report. I need to add two user parameters and a field retrieved should be between them if they are not left blank. If they are left blank, then, they should not be taken into consideration. My problem is: These two parameters are included in my...

    Nafy5 pointsBadges:
  • How do we work with SQL?

    How do we work with SQL and what does it help in DBMS?

    veronicahmungai20 pointsBadges:
  • Transpose SQL (Pivot) columns to rows

    I need to pivot my records in columns into rows. Here is sample data: create table #columnstorows ( Payer varchar (5), ID varchar (5), ClM varchar (2), Paid1 float, Paid2 float, Paid3 float ) go insert into #columnstorows (Payer, ID, ClM ,Paid1, Paid2,Paid3) select...

    helalmob5 pointsBadges:
  • How to transition an old local CRM system to a more modern networked CRM Solution

    Hi. We have an old CRM system that is currently local to only a single location and we are looking to transition it to a more modern system with network capability and would appreciate any advice about the best way to go about it. Basically, we currently have a fairly simple Microsoft Access (2007)...

    ericw19755 pointsBadges:
  • 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 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?

    BibekMajilla70 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:

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