SQL auto increment by group with INSERT..
Is it possible to define an auto-incremental coloumn which increments by 'group' ? I want to create a version log for an old table (uniquely keyed 'HOWTONO') which contains records with 'How to' data in the form of short code-fields and some long fields with text. I intend to trigger updates,...
Is it possible to define an auto-incremental coloumn which increments by 'group' ? I want to create a version log for an old table (uniquely keyed 'HOWTONO') which contains records with 'How to' data in the form of short code-fields and some long fields with text. I intend to trigger updates,...
245 pts.
Bulk-Logged Recovery Model SQL Server 2005
If I change the recovery model on the database from full to bulk-logged to run DBCC CheckDB and Rebuild Indexes is changing the recovery model the correct thing to do? Software/Hardware used: SQL Server 2005
If I change the recovery model on the database from full to bulk-logged to run DBCC CheckDB and Rebuild Indexes is changing the recovery model the correct thing to do? Software/Hardware used: SQL Server 2005
SQL cursor question
hi, i've SQLRPGLe program in which i'm writing a cursor to select all records, order them by a field A (suppose employee number). And once all the rows fetched for an employee and printed, print the count at the bottom. Repeat this for all the subsequent employees.... i'm not sure how to...
hi, i've SQLRPGLe program in which i'm writing a cursor to select all records, order them by a field A (suppose employee number). And once all the rows fetched for an employee and printed, print the count at the bottom. Repeat this for all the subsequent employees.... i'm not sure how to...
AS/400 SQL BLOBS
I am trying to read data from a SQL table that contains a BLOB of 10MB. Since the RPG field size is limited to 32KB, is this even possible? Software/Hardware used: AS/400SQL
I am trying to read data from a SQL table that contains a BLOB of 10MB. Since the RPG field size is limited to 32KB, is this even possible? Software/Hardware used: AS/400SQL
text data to packed
i have comp-3 data in a text field. i need to extract the info and convert it back to numerics to download to a pc. i want to use sql ... Software/Hardware used: as/400- client
i have comp-3 data in a text field. i need to extract the info and convert it back to numerics to download to a pc. i want to use sql ... Software/Hardware used: as/400- client
Using SRCDBG with an SQLRPGLE module
I'm trying to debug a RPGLE module created with CRTSQLRPGI. The STRDBG program returns an error message stating the program "cannot be accessed". There is no DBGVIEW option on the CRTSQLRPGI command, so even if I get the debug to work. will I see any source data? Thanks. Software/Hardware used:...
I'm trying to debug a RPGLE module created with CRTSQLRPGI. The STRDBG program returns an error message stating the program "cannot be accessed". There is no DBGVIEW option on the CRTSQLRPGI command, so even if I get the debug to work. will I see any source data? Thanks. Software/Hardware used:...
Using MS Acess SQL Passthrough To AS400 to find wholes in number sequence between to files
Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I know...
Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I know...
Reformatting SQL Data in a Field
Hi, I'm new to the whole SQL experience and need help converting some data. In our Activity table, data was imported into the UF_4 field incorrectly. We want to convert this data "from a Decimal format" to a “NonDecimal”. Currently the data looks like 5234.000 and we want it to look like...
Hi, I'm new to the whole SQL experience and need help converting some data. In our Activity table, data was imported into the UF_4 field incorrectly. We want to convert this data "from a Decimal format" to a “NonDecimal”. Currently the data looks like 5234.000 and we want it to look like...
rollback command in sql
suppose user x insert values into table t1,and then update the table t1,after then he wants to increase the size of column c1.then he wants to rollback upto update values.he can do this or not,if yes then what is the right procedure? Software/Hardware used: software
suppose user x insert values into table t1,and then update the table t1,after then he wants to increase the size of column c1.then he wants to rollback upto update values.he can do this or not,if yes then what is the right procedure? Software/Hardware used: software
USROPN file in SQLRPGLE
I have a SQLRPGLe program. Certain files are not available at client terminal depending upon the applications purchased by client. I have a common program called from all applications and hence i user open the files based on the application types. my confusion is if i refer a file directly in SQL...
I have a SQLRPGLe program. Certain files are not available at client terminal depending upon the applications purchased by client. I have a common program called from all applications and hence i user open the files based on the application types. my confusion is if i refer a file directly in SQL...
AS400 File to MS Access by SQL Passthrough Query
I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM...
I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM...
Display Bug with CFTextArea?
Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query...
Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query...
Crystal 8 & SQL problem
I created 80+ reports for the company intranet and they worked great. At the time the ODBC's were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet...
I created 80+ reports for the company intranet and they worked great. At the time the ODBC's were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet...
AS/400 SQL
want to all some users to run an SQL for display only and not allow update of delete. is there a way to do this
want to all some users to run an SQL for display only and not allow update of delete. is there a way to do this
Refresh/Run SQL
We upgraded to Crystal Reports 2008. Our older version queries appear to work... In the Older Verion all we did is click the lightening blot. Now... we have to go through Database, SQL to run/refresh the query. Isn't there a one click key for to run these queries?
We upgraded to Crystal Reports 2008. Our older version queries appear to work... In the Older Verion all we did is click the lightening blot. Now... we have to go through Database, SQL to run/refresh the query. Isn't there a one click key for to run these queries?
SQL upload images problem
hello glad to be here, i have a upload images tutoiral that i got from here http://geekswithblogs.net/dotNETvinz...n-asp.net.aspx but i can not get it to work, it is slightly tweaked for me. errors i am getting are: ------ Build started: Project: C:\WebSite4\, Configuration: Debug Any CPU...
hello glad to be here, i have a upload images tutoiral that i got from here http://geekswithblogs.net/dotNETvinz...n-asp.net.aspx but i can not get it to work, it is slightly tweaked for me. errors i am getting are: ------ Build started: Project: C:\WebSite4\, Configuration: Debug Any CPU...
Finding differences between 2 files using sql
I am on V5R2 and am trying to find differences between a production file and an archived file using the following sql stmt: SELECT MAX(Filename), PORD, PLINE FROM (SELECT 'HPO' as Filename, PORD,PLINE from HPOL01 UNION ALL SELECT 'ARC' as...
I am on V5R2 and am trying to find differences between a production file and an archived file using the following sql stmt: SELECT MAX(Filename), PORD, PLINE FROM (SELECT 'HPO' as Filename, PORD,PLINE from HPOL01 UNION ALL SELECT 'ARC' as...
SQL select command
Hi i hope all doing well, i have a problem with this SQL select command : **************************************************************** SELECT DISTINCT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price,...
Hi i hope all doing well, i have a problem with this SQL select command : **************************************************************** SELECT DISTINCT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price,...
SQL Error
we need to determine error message:the condition applied to this collectioncontains an ORDER BY without a corresponding TOP clause.
we need to determine error message:the condition applied to this collectioncontains an ORDER BY without a corresponding TOP clause.
