See SQL statements sent on ODBC connection

We have an application that uses ODBC to connect (and possibly make changes) to our SQL database. But at the end of the day, the results are wrong. Because of that, we would like to see all of the SQL statements that were sent. Can we do that in ODBC? Thank you.

ITKE1,067,645 pointsBadges:

SQL: Which part should I execute first in which manner?

What should I execute first? proc sql; select distinct e.firstname, e.lastname from sasuser.flightschedule as sasuser.staffmaster as b, sasuser.payrollmaster as sasuser.supervisors as d, sasuser.staffmaster as e where a.date=’04mar2000’d and a.destination=’CPH’ and a.empid=b.empid and...

kapil956365 pointsBadges:

Editing date field in SQL

Can we edit date field in SQL select statement?

Msatbh185 pointsBadges:

Converting DB2 Timestamp to UTC milliseconds

I'll get right to my point - would I be able to convert my DB2 timestamp into UTC milliseconds? Is there a function to do this? And yes - I'm currently doing this in SQL.

ITKE1,067,645 pointsBadges:

Dump content from IBM DB2 schema into SQL text file

For the past few days, I've been trying to dump content from a schema (that's from a IBM DB2 server) into a SQL text file. But I'm running into a dead end. What should I do here? Is there anything like mysqldump for MySQL? Thank you.

ITKE1,067,645 pointsBadges:

DB2 table columns description

I'm using DB2 - I need to know the description of all the columns in my table. Can I do this using SQL? Thanks so much.

ITKE1,067,645 pointsBadges:

Types of JOINs in SQL

What are the types of JOINs in SQL?

vijaykumar110 pointsBadges:

How to use Crystal Reports with LINQ to SQL

I know this is a broad question but this is the only way I can ask the question. I use Crystal Reports all the time. Is there a way I can use that with LINQ to SQL? At least someone can point me in the right direction, right? Thanks.

ITKE1,067,645 pointsBadges:

Logical File key not working

I am creating a new logical over a physical file. Very basic. Just one key field. It is a character file as the key. R RUB04000 PFILE(RUB0400F) K TRALER. After I create the logical file successfully and check the records, the records are NOT in the sequence as defined in the logical file DDS. I...

Philcards15 pointsBadges:

How do SQL related to this program?

Can anyone tell me how SQL is related to my program?

nlhabal5 pointsBadges:

SQL: Storing data in a column

Sir, I want to know that in a table there are three columns like A, B, C. And I want to store the data on only A, B. When I insert the data, it automatically puts the result in C.

Raju12345 pointsBadges:

Access SQL: Records from the Vendors table

For Access SQL, how do I save records from a vendor's table

NikiaBainton5 pointsBadges:

SQL query for descending order

How do I input only each product’s name and sort them alphabetically (in descending order from Z-A)?

ProfRockhill5 pointsBadges:

Oracle SQL script to deactivate customers records with possible multiple debt some paid some not paid

I want to write a Oracle SQL script that will only deactivate a customer record with no outstanding debt.

lindadawes5 pointsBadges:

SQL: In responsiblity wise last 5 transactions details request as on 31.03.2016

AS per audit review request: All responsibility wise AP, AR, GL, CM , FA , PO, Inv last 5 transactions taken from the SQL as given date for 31.03.2016.  Please help on our request.

Thillainathan5 pointsBadges:

SELECT hex in SQL shows error

I am a python student. this instruction: SELECT hex(User.name || Course.title || Member.role ) AS X FROM User JOIN Member JOIN Course ON User.id = Member.user_id AND Member.course_id = Course.id ORDER BY X When I run it shows invalid syntax. I am taking a python course but I know very little about...

cmorenme5 pointsBadges:

Can I load data using SQLLDR into an in-memory table?

Can I load data using SQLLDR into an in-memory table and is this the best way? Thanks so much.

rG1234565 pointsBadges:

SQL query for top 5 sales

I want a query through which I can get a record of last one year sales. And it should show top 5 records for every day.

atifmushtaq5 pointsBadges:

TMS configuration during migration to HEC

Hi all, We are migrating to HANA Enabled cloud from On-Premise landscape. Current landscape is D->Q->R->P After phase two, R and D will be on HEC and rest on-premise. Trans directory is set as D. OS/DB will be changed to Linux/Sybase from Windows/SQL. Please let me know if TMS...

BASIS125 pointsBadges:

How to left or right justifying a text file

Hello programmers. I am using SQL to create a table from stored procedures and then streamwriter in VB.NET to create a text file based on the SQL table. Where and how do I control the right or left justification of the records in the text file? Thx.

Ilfoprog50 pointsBadges: