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.

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

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.

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

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?

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

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

Cobol uses some kind of IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the code would like. How would the updated file be...

I currently have an SQLRPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

I would like to solve this following complex script in SQL by using Visual Basic, either version 5.0 or 6.0. My first table name is tblClient, with fields ClientID and ClientName. My second table name is tblPurchase, with fields ClientID, Item Name, Qty and Price. I would like to pass one SQL query...

To follow this tag...

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