• VB.NET applications with database to web applications

    I have a VB.NET applications with SQL database and I would like to convert or migrate to web Applications. Any help or advise?

    jaakinyemi5 pointsBadges:
  • Run list of queries in particular library using SQL on AS/400

    I want to know how to run a list of queries in a particular library using SQL on the AS/400. Is that possible?

    ORLANDODUBLIN15 pointsBadges:
  • AS/400 physical file

    Pf 1 file contain records below: Roll No Subject Marks 1           S1         100 2           S2          80 1           S1          60 2           S2          70 Another file PF2 Contain records below, Roll No Marks 1           180 2         ...

    vivekntt21435 pointsBadges:
  • OVRDBF on iSeries used in a CL program

    I am using an SQL statement to insert into a file. I am doing some sub-stringing on a record then inserting into another file. I am getting a LVLCHK error on the output file. How can I use OVRDBF in my CL to insert to my output file? My file PROFILE has the data and PROFILE2 is my output file and...

    Rrbond07520 pointsBadges:
  • Select statement stopped listing records

    The statement is only selecting syntax and not listing records. Process parameter is *RUN. It was working earlier.

    gamurtuza35 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:
  • How to run queries from SEQUEL ViewPoint

    How can I run queries from SEQUEL ViewPoint?

    tonycurtis405 pointsBadges:
  • Create an Entity Relationship Diagram for a working database (SQL developer)?

    How can I create an Entity Relationship Diagram for a working database (SQL Developer)?

    sonali00725 pointsBadges:
  • Execution plan cost checking in SQL Server 2012

    How can I analyze SQL Server Execution plan in that cost percentage (need more clarification for physical operation, logical operation, CPU cost)?

    kowshi5 pointsBadges:
  • Does listener comes into play whenever client queries every single SQL statement?

    Does the listener comes into play whenever client queries every single SQL statement or it (listener) just connects one time only?

    praveenkns5 pointsBadges:
  • RPG SQL Nomain Module with DSPF

    I have Cycle Program with embedded SQL that updates table using display file. What do I have to do to create a module, so it will be compiled to *PGM object?

    FlashSmile5 pointsBadges:
  • Create ER diagram in Oracle SQL Developer

    I'm fairly new to Oracle SQL Developer and I'm trying to create an ER diagram for my database tables. How can I go about this process? Any help would be appreciated.

    ITKE1,072,150 pointsBadges:
  • DB2 hex values in SQL causing problem

    Ok here's one I cannot figure out. Here are the PO#s that show in our green screen software and they look fine     5-824101 S1079682 33­-548504­-D RMA 001904          REASON CODE 11  8075-089          1V 76139-6200        88   But if I write a SQL to extract them the PO#...

    ToddN2000102,460 pointsBadges:
  • Track data from SQL Server 2005 in Visual Studio

    How can I track data from SQL Server 2005 in Visual Studio?

    friska9075 pointsBadges:
  • Connect SQL local server group using CMD

    This is a short but concise question: I just created a MS SQL Local server group. Now, can I connect to that through CMD? If you can just point me in the right direction, that would be great.

    ITKE1,072,150 pointsBadges:
  • Filling online form but has failed to execute SQL

    I'm filling an online form but has failed to execute SQL. What should I do?

    Natotec15 pointsBadges:
  • AS/400 Embedded SQL, RPGLE free format, compilation

    1. My Problem: I am not able to compile a RPGLE free format PGM with embedded SQL. 2. My simple basic code: exec sql select RAGNA from RPFAGE ; *inlr = *on ;  (RPGAGE is the PF name and RAGNA is one of the fields in PF RPGAGE PF contains 100 records) 3, Member type is SQLRPGLE 4. Compile command:...

    anandx715 pointsBadges:
  • How to link Microsoft Excel file in SSMS 2014

    I'm using SSMS 2014 and I'm able to link an Excel file as a linked server. But here's my question: Now I want to link multiple Excel files. Can I link all of the files on a linked server or do I have to do them separately? Meaning one linked server for one Excel file.

    ITKE1,072,150 pointsBadges:
  • SQL query: Get result from row3 and row6 only sometime row1 and 10 only

    PRIMARY KEY (A/C. NO.) ALSO EXISTS IN TABLE2 AND TABLE 3 TABLE1 TABLE2 TABLE3 TABLE3 a/c. no. Consum demand dues 65138546 2500 193 193 65138546 3100 696 696 65138546 3500 700 700 65138546 4000 763 763 65138546 6000 867 867 65138546 7000 1125 1888 65138546 8000 1281 1281 65138546 9000 1594 1594...

    235235235305 pointsBadges:
  • Extract SQL from older unknown Crystal Report .rpt file

    I have an unknown version of Crystal Report .rpt file. I would like to analyze the SQL only - is it reasonably possible to extract the SQL?

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

Thanks! We'll email you when relevant content is added and updated.

Following