Why sqlcode error=100 comes ?
Hello, Found your answer from Jane Hunt on … http://www.dbmonster.com/Uwe/Forum.aspx/informix/2034/Re-Error-100 From the Informix Error Messages manual: 100 No matching records found. The database server did not find any more data. This message is an ANSI-standard SQLCODE value. If you attempted to select or fetch data, you encountered the end of the data, or no data [...]
View Answer
| August 21, 2008 4:16 PM
Informix, ISAM, SQL, sqlcode error=100
Hello, Found your answer from Jane Hunt on … http://www.dbmonster.com/Uwe/Forum.aspx/informix/2034/Re-Error-100 From the Informix Error Messages manual: 100 No matching records found. The database server did not find any more data. This message is an ANSI-standard SQLCODE value. If you attempted to select or fetch data, you encountered the end of the data, or no data [...]
View Answer
| August 21, 2008 4:16 PM
Informix, ISAM, SQL, sqlcode error=100
Switch/Case statment in access
You can go many different ways; so without knowing your 200 codes, I can give a preferred suggestion; but it may not work for your situation. If the characters are a consitent length, you could use queries and tables to get what you need. Example: Make a table called ActionTable and add columns Action and [...]
View Answer
| August 21, 2008 3:05 PM
Access 2003, CASE statement, Database programming, Microsoft Access
You can go many different ways; so without knowing your 200 codes, I can give a preferred suggestion; but it may not work for your situation. If the characters are a consitent length, you could use queries and tables to get what you need. Example: Make a table called ActionTable and add columns Action and [...]
View Answer
| August 21, 2008 3:05 PM
Access 2003, CASE statement, Database programming, Microsoft Access
Access database management
Simply link the table (Get External Data – Link) from the history database into your current database. Say the table in current is Work and you would link WorkHistory from the history database. Now both databases are in you main application database. Then as the work is compelete, you could make an append query to [...]
View Answer
| August 21, 2008 2:25 PM
Database, Database programming, Microsoft Access
Simply link the table (Get External Data – Link) from the history database into your current database. Say the table in current is Work and you would link WorkHistory from the history database. Now both databases are in you main application database. Then as the work is compelete, you could make an append query to [...]
View Answer
| August 21, 2008 2:25 PM
Database, Database programming, Microsoft Access
processing biometric data
Most of the biometric machines come with a base software and most of these software are able to give the data in raw format (text, csv, excel etc,) that can be uploaded to some database (through automated process or manually) and processed for various purposes.
View Answer
| August 21, 2008 11:28 AM
Biometrics, Microsoft Access, Microsoft Excel
Most of the biometric machines come with a base software and most of these software are able to give the data in raw format (text, csv, excel etc,) that can be uploaded to some database (through automated process or manually) and processed for various purposes.
View Answer
| August 21, 2008 11:28 AM
Biometrics, Microsoft Access, Microsoft Excel
SQL insert statement
METHOD is a reserved word in SQL. Naming convention suggests that you prefix all of your column names with an identifier. This could be related to the table name, so you could use something like AS_Employee, AS_Date etc
View Answer
| August 20, 2008 7:44 PM
ASP, INSERT statement, SQL
METHOD is a reserved word in SQL. Naming convention suggests that you prefix all of your column names with an identifier. This could be related to the table name, so you could use something like AS_Employee, AS_Date etc
View Answer
| August 20, 2008 7:44 PM
ASP, INSERT statement, SQL
Embedded SQL in RPG ILE
First, your program will need to determine which file (and fields) the user wants. You may need to query the system file SYSCOLUMNS to help with this. Then you will need to dynamically write the SQL statement into a variable in the program, use that variable in a PREPARE statement, and use that to DECLARE [...]
View Answer
| August 20, 2008 2:48 PM
Embedded SQL, iSeries, RPG, RPGLE, RPGSQL
First, your program will need to determine which file (and fields) the user wants. You may need to query the system file SYSCOLUMNS to help with this. Then you will need to dynamically write the SQL statement into a variable in the program, use that variable in a PREPARE statement, and use that to DECLARE [...]
View Answer
| August 20, 2008 2:48 PM
Embedded SQL, iSeries, RPG, RPGLE, RPGSQL
Overlapping data on a merge replication between three SQL Servers
This is one of the potential issues when using merge replication. Within the Publication properties you should be able to set the identity range size. When merge replication fires up it assigns a range of IDs to each server. These IDs are the ranges which should be used by each server when new records are [...]
View Answer
| August 19, 2008 8:19 PM
Merge replication, Primary keys
This is one of the potential issues when using merge replication. Within the Publication properties you should be able to set the identity range size. When merge replication fires up it assigns a range of IDs to each server. These IDs are the ranges which should be used by each server when new records are [...]
View Answer
| August 19, 2008 8:19 PM
Merge replication, Primary keys
hired by a company using AS/400
Hi, <a href=”http://krypton.mnsu.edu/~j3gum/web/as400/intref.html”>Maybe this will help</a> Regards, Martin Gilbert. Hired to do what? Adminstration?
View Answer
| August 19, 2008 8:09 PM
AS/400 careers, Career development, IT careers
Hi, <a href=”http://krypton.mnsu.edu/~j3gum/web/as400/intref.html”>Maybe this will help</a> Regards, Martin Gilbert. Hired to do what? Adminstration?
View Answer
| August 19, 2008 8:09 PM
AS/400 careers, Career development, IT careers
crosstab query
two links that can help you in understanding basics about crosstab in mysql are: 1. <a href=”http://lists.mysql.com/mysql/183114″>mysql.com</a>: http://lists.mysql.com/mysql/183114 and 2. <a href=”http://www.mysqltalk.org/crosstab-in-mysql-vt157209.html”>mysqltalk.org</a>: http://www.mysqltalk.org/crosstab-in-mysql-vt157209.html
View Answer
| August 19, 2008 5:02 PM
CrossTab Query, SQL, VB.NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005
two links that can help you in understanding basics about crosstab in mysql are: 1. <a href=”http://lists.mysql.com/mysql/183114″>mysql.com</a>: http://lists.mysql.com/mysql/183114 and 2. <a href=”http://www.mysqltalk.org/crosstab-in-mysql-vt157209.html”>mysqltalk.org</a>: http://www.mysqltalk.org/crosstab-in-mysql-vt157209.html
View Answer
| August 19, 2008 5:02 PM
CrossTab Query, SQL, VB.NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005
Actuate 8 enterprise reporting tool,Text files
One solution is that you can open this delimited file in excel and change the separator from backslash to comma.
View Answer
| August 19, 2008 3:18 PM
Actuate, Actuate 8, Database reporting, Flat files
One solution is that you can open this delimited file in excel and change the separator from backslash to comma.
View Answer
| August 19, 2008 3:18 PM
Actuate, Actuate 8, Database reporting, Flat files
Shifting to ABAP from Java
It is not too late to change your stream from Java to SAP ABAP. Maybe initially you might not get a lucrative break but otherwise future is good in ABAP.
View Answer
| August 19, 2008 3:13 PM
ABAP, Career development, IT careers, IT jobs, Java, SAP careers
It is not too late to change your stream from Java to SAP ABAP. Maybe initially you might not get a lucrative break but otherwise future is good in ABAP.
View Answer
| August 19, 2008 3:13 PM
ABAP, Career development, IT careers, IT jobs, Java, SAP careers
Prospects for Mechanial engineer in SAP MM
Customer Service experience and engineering background will be an added advantage for your future in SAP MM.
View Answer
| August 19, 2008 3:11 PM
Career development, Certifications, IT careers, IT jobs, SAP careers, SAP certifications, SAP MM
Customer Service experience and engineering background will be an added advantage for your future in SAP MM.
View Answer
| August 19, 2008 3:11 PM
Career development, Certifications, IT careers, IT jobs, SAP careers, SAP certifications, SAP MM
How do I retrieve the most recent date from an access database
You probably need to write a SQL query to do this. Try something like this: select * from service_call where customer_id = form.customer_id and call_date = (select max(call_date) from service_call where customer_id = form.customer_id);
View Answer
| August 18, 2008 2:28 PM
Access 2003, Access Database, Microsoft Access
You probably need to write a SQL query to do this. Try something like this: select * from service_call where customer_id = form.customer_id and call_date = (select max(call_date) from service_call where customer_id = form.customer_id);
View Answer
| August 18, 2008 2:28 PM
Access 2003, Access Database, Microsoft Access
Has the job market in IT gotten older?
Dear Sir: As an “aging baby boomer” (like myself: I’m 56) you will be at something of a disadvantage in the job market, mostly because employers prefer to hire people in their 30s and 40s (enough experience to be useful, still junior enough on the career path not to be too expensive). If you can [...]
View Answer
| August 16, 2008 10:40 PM
Career development, IT careers, Job, Networking, Networking careers, Training
Dear Sir: As an “aging baby boomer” (like myself: I’m 56) you will be at something of a disadvantage in the job market, mostly because employers prefer to hire people in their 30s and 40s (enough experience to be useful, still junior enough on the career path not to be too expensive). If you can [...]
View Answer
| August 16, 2008 10:40 PM
Career development, IT careers, Job, Networking, Networking careers, Training
How can I switch into the networking field from a software development background?
Dear Sir or Madam; Sometimes short questions like yours imply a world of additional information; always they fail to include it. In the absence of more specifics about exactly what it is that you’re currenty doing, what you do and don’t like about it, and what’s impelling you to move away from that work I [...]
View Answer
| August 16, 2008 3:00 PM
branch IT, Engineers, IT careers, IT training and certifications, Networking, Software development
Dear Sir or Madam; Sometimes short questions like yours imply a world of additional information; always they fail to include it. In the absence of more specifics about exactly what it is that you’re currenty doing, what you do and don’t like about it, and what’s impelling you to move away from that work I [...]
View Answer
| August 16, 2008 3:00 PM
branch IT, Engineers, IT careers, IT training and certifications, Networking, Software development
how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive.
Hi, Please see website for commands to use… http://www.itjungle.com/fhg/fhg032404-story02.html
View Answer
| August 15, 2008 2:58 PM
Batch job, CL, Flat files, PF/LF
Hi, Please see website for commands to use… http://www.itjungle.com/fhg/fhg032404-story02.html
View Answer
| August 15, 2008 2:58 PM
Batch job, CL, Flat files, PF/LF
Join clause vs. nonequi join
The syntax for a normal join (equi-join) is similar to a non-equi-join where the criteria statement simply has an inequality vs. an equality. For example an equi-join usually looks like this: select * from tablea join tableb on tablea.key = tableb.key; a non-equi-join looks like this: select * from tablea join tableb on tablea.key <> [...]
View Answer
| August 15, 2008 2:09 PM
Join logical files, JOIN statement, Oracle developers
The syntax for a normal join (equi-join) is similar to a non-equi-join where the criteria statement simply has an inequality vs. an equality. For example an equi-join usually looks like this: select * from tablea join tableb on tablea.key = tableb.key; a non-equi-join looks like this: select * from tablea join tableb on tablea.key <> [...]
View Answer
| August 15, 2008 2:09 PM
Join logical files, JOIN statement, Oracle developers
Reindex DBF file from Ms-SQL 2000
A DBF file is typically a dbase file (where dbase is a specific database platform seperate from Microsoft SQL Server). I suppose that it’s possible that you could fire off a command via the linked server to create or modify an index via a linked server to the dbase system, however that wouldn’t be recommended. [...]
View Answer
| August 15, 2008 12:18 PM
DBF file, Linked servers, SQL Server 2000
A DBF file is typically a dbase file (where dbase is a specific database platform seperate from Microsoft SQL Server). I suppose that it’s possible that you could fire off a command via the linked server to create or modify an index via a linked server to the dbase system, however that wouldn’t be recommended. [...]
View Answer
| August 15, 2008 12:18 PM
DBF file, Linked servers, SQL Server 2000
Job at SAP
I believe you can be successful in a position with SAP. If they are willing to train you upon hiring, chances are they will (re)train you if business trends change. The recent article <a href=”http://www.albawaba.com/en/countries/UAE/233755″>SAP Named Global Market Share Leader in Business Solutions</a> cites Gartner rankings to back up SAP’s value as an employer. Best [...]
View Answer
| August 14, 2008 6:58 PM
ABAP, IT careers, SAP careers
I believe you can be successful in a position with SAP. If they are willing to train you upon hiring, chances are they will (re)train you if business trends change. The recent article <a href=”http://www.albawaba.com/en/countries/UAE/233755″>SAP Named Global Market Share Leader in Business Solutions</a> cites Gartner rankings to back up SAP’s value as an employer. Best [...]
View Answer
| August 14, 2008 6:58 PM
ABAP, IT careers, SAP careers
How Do I Fix A Implicit conversion Error
The problem is the IS_NULL functions that I pointed you towards. I didn’t release the data types in the prior post. You can’t have a blank value in a field which is a numeric data type (of which the money data type is one). Try changing the IS_NULL functions to this. <pre>SELECT DISTINCT oas_balance.cmpcode, oas_balance.el1, [...]
View Answer
| August 14, 2008 6:56 AM
Implicit Conversion Error, SQL
The problem is the IS_NULL functions that I pointed you towards. I didn’t release the data types in the prior post. You can’t have a blank value in a field which is a numeric data type (of which the money data type is one). Try changing the IS_NULL functions to this. <pre>SELECT DISTINCT oas_balance.cmpcode, oas_balance.el1, [...]
View Answer
| August 14, 2008 6:56 AM
Implicit Conversion Error, SQL
