• Declare Cursor in AS/400 COBOL

    I have and SQLCBL program that declares a cursor, opens the cursor, and then does a fetch to process the data in the cursor. The fetch is not always retrieving the first record in the file. It's my understanding that the open positions the pointer right before the first record and that the Fetch...

    rdgribben15 pointsBadges:
  • Delete million of rows by ID in SQL

    We're trying to delete roughly 2 million rows from our PG database. We already have a list of IDs that need to be deleted but it's turning into a slow process. This is what I tried: DELETE FROM tbl WHERE id IN (select * from ids) So basically, this is taking about 2 days to finish. Is there a...

    ITKE355,655 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...

    rinkyyy5 pointsBadges:
  • DFU (UPDDTA) and changing Keys

    DFU (UPDDTA) and changing keys - We support a number of users of the same software. then we try to change a key field in a file with DFU it doesn't always allow us to do so. Sometimes the user does not have access to the key field, sometimes they do. Each user is the owner of the file and has...

    Bamba6125 pointsBadges:
  • Performing SQL Join equivalent in MongoDB

    Does anyone know of a way to perform a SQL Join equivalent in MongoDB? This is what I have right now: comments { uid:12345, pid:444, comment="blah" } { uid:12345, pid:888, comment="asdf" } { uid:99999, pid:444, comment="qwer" } users { uid:12345, name:"john" } { uid:99999, name:"mia" } And I'm...

    ITKE355,655 pointsBadges:
  • Extracting SQL query output in HTML file through UNIX script

    I have made a Unix script in which m spooling the output of a sql query in TEST>HTML file. Now I want to add colors and style tag in the output so as to make it more visually appealing.

    parnita5 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • SQL join for two files with identical field names

    When joining 2 files that have identical field names, what does the syntax need in order to handle this? I know the old IBM Query uses a file prefix. On AS/400 platform (DB2)

    aceofdelts2,080 pointsBadges:
  • Logical file changes and SQL

    I need to make a change to a logical file. I have a program that is accessing this logical via an SQL statement. If I recompile the logical, do I have to recompile the program as well? (the file is not listed in the 'F' specs, it's only referenced in the SQL statement.

    NJSTATEBOB25 pointsBadges:
  • Trap SQLCODE from RUNSQLSTM

    I have a RUNSQLSTM that updates a table. When it hits a duplicate, it quits and returns SQL9010. What I want it to do is just skip the step that got a duplicate and move on. Is there a way to do this?

    khalon25 pointsBadges:
  • Text string gets SQL0406 via AS/400 RUNSQLSTM but works interactively

    I am doing an insert into a table and it works perfectly when run interactively on the iSeries but gets "SQL0406 229 Position 1 Conversion error on assignment to column BUDSPERSON". The field is Character, length 35.  The query is: insert into slsbudter ( SELECT ALLNUMS.BU, ALLNUMS.BUSUNIT,...

    randycoxclemson5 pointsBadges:
  • Data Source in SQL

    What is the data source in SQL

    botauk15 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:
  • Case statement with Strings in a SQL statement

    I have a SQL statement that DOES work to create a bit of a pivot table. select JOB#, sum(CASE when COURSE#=’36’ then MONTHS  end) as “Training” from FILE where group by JOB# However, what I need is instead of showing the sum of the months, I want to show the string field on if it was...

    spishane25 pointsBadges:
  • Questions around SQL

    What is data modeling? Why is the data modeling important? What makes a good data modeling? Where do data models fit in? Who should be involved in data modeling? And why? What is database? What is DBMS? What is RDBMS? What are advantages to using DBMS? What are disadvantages to using DBMS?

    shravangudikadi12310 pointsBadges:
  • Running AS/400 query

    SQLCODE -104 while preparing statement in SQL . Eval Sqlstmt1= 'Insert Into' + ' ' + %Trim(WRKTLIBR) +'/' +%Trim(WRKFILE) + ' '+'(Select * from '+ %Trim(WRKLIBR) + '/' + %Trim(WRKFILE) + ' ' + 'A' + ' ' + 'Where Exists (Select * from CSTBYUNQL1 B ' +' Where B.Compny = A.' +%Trim(WRKCMP) + ' and '+...

    abhisheka1405 pointsBadges:
  • SAP on SQL Server and NetApp

    Hi everyone, we are looking for some feedback from anyone who has used NetApp with SAP running on a SQL database. We are researching white papers, etc., but would really like to hear from some folks with hands on experience. What has your experience been like? Any performance hits? Any caveats or...

    DebDonohoe5 pointsBadges:
  • SQL Agent in SQL environment?

    What is SQL Agent in SQL Environment?

    Prcvjr220 pointsBadges:
  • Run Oracle 9i with Windows Server 2003 Domain Controller

    Sir, I have Windows Server 2003 server with DC. I just want to install Oracle 9i server on that server and configure client on Windows XP client side. I want to run Oracle 9i client through domain user. Is there any setting or rights of domain user that the user will be able to run oracle...

    Swapnesh15 pointsBadges:
  • Where is the best site to learn SQL?

    Where is the best site(s) to learn SQL? A place with example coding etc...

    JHAMLW5 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