Access 2007 IIF statement in query criteria
<pre> It looks like you are trying to use the IIF statement to branch query results when it is only meant to provide an either or value for a single field. Example: If the check-box is true, fieldA is this value. If the check-box is true, fieldA is another value. You are trying to use [...]
View Answer
| November 13, 2009 6:55 PM
Access 2007, IIF statement, Microsoft Access
<pre> It looks like you are trying to use the IIF statement to branch query results when it is only meant to provide an either or value for a single field. Example: If the check-box is true, fieldA is this value. If the check-box is true, fieldA is another value. You are trying to use [...]
View Answer
| November 13, 2009 6:55 PM
Access 2007, IIF statement, Microsoft Access
Join our ITKnowledgeExchange.com LinkedIn group
<b> manual to use file server software </b>
View Answer
| November 13, 2009 6:33 PM
AS/400, CIO, Database, DataCenter, Development, Exchange 2003, Linux, Lotus Domino, Mobile, Oracle, Security, SQL Server, Storage, Virtualization, VoIP, Windows
<b> manual to use file server software </b>
View Answer
| November 13, 2009 6:33 PM
AS/400, CIO, Database, DataCenter, Development, Exchange 2003, Linux, Lotus Domino, Mobile, Oracle, Security, SQL Server, Storage, Virtualization, VoIP, Windows
IT career requirements for Java?
Java and Programming in general is still good to have. You don’t necessarily need it, but it will help with small projects. As a Systems Administrator, it will help, but if you are planning on becoming a Network engineer, you won’t need it.
View Answer
| November 11, 2009 11:16 PM
Career development, Information technology systems, IT, IT careers, IT education, IT training, Java, Java programming, Network and system management, Networking, Programming Languages
Java and Programming in general is still good to have. You don’t necessarily need it, but it will help with small projects. As a Systems Administrator, it will help, but if you are planning on becoming a Network engineer, you won’t need it.
View Answer
| November 11, 2009 11:16 PM
Career development, Information technology systems, IT, IT careers, IT education, IT training, Java, Java programming, Network and system management, Networking, Programming Languages
Trigers
I am unclear on what exactly you want to know. The general process is to 1) write the RPGLE program that contains the instructions you want to execute when a record is added to the PF; 2) compile the program; 3) attach the RPGLE object to the physical file using the CHGPF command or the [...]
View Answer
| November 11, 2009 7:51 AM
AS/400, DB2 Universal Database, RPG
I am unclear on what exactly you want to know. The general process is to 1) write the RPGLE program that contains the instructions you want to execute when a record is added to the PF; 2) compile the program; 3) attach the RPGLE object to the physical file using the CHGPF command or the [...]
View Answer
| November 11, 2009 7:51 AM
AS/400, DB2 Universal Database, RPG
Problems with Stored Procedures
A couple people wrote in with advice. Here’s what they said: “Terri still needs to turn the *Module object into a *Pgm object.” – Randy Adamski “When I’ve had this problem it was always because I wasn’t invoking the stored procedure with the required parameters. This is with the same parameters and the same size [...]
View Answer
| November 11, 2009 6:00 AM
DB2 Universal Database, RPG
A couple people wrote in with advice. Here’s what they said: “Terri still needs to turn the *Module object into a *Pgm object.” – Randy Adamski “When I’ve had this problem it was always because I wasn’t invoking the stored procedure with the required parameters. This is with the same parameters and the same size [...]
View Answer
| November 11, 2009 6:00 AM
DB2 Universal Database, RPG
Superseded PTFs.
it’s a cum ? (a cumulative PTF) if yes, the requested PTF in in the cum. if no, ask it from IBM (command SNDPTFORD) ======================================================= No. Tom
View Answer
| November 11, 2009 4:27 AM
AS/400, Database, DB2 Universal Database, RPG
it’s a cum ? (a cumulative PTF) if yes, the requested PTF in in the cum. if no, ask it from IBM (command SNDPTFORD) ======================================================= No. Tom
View Answer
| November 11, 2009 4:27 AM
AS/400, Database, DB2 Universal Database, RPG
VB.NET code to search if a record already exists or not
If you are getting errors with the code you posted, please provide the exact error messages or tell us what the problem with that code is. If this code is working but you want to add the necessary logic to check if the record already exists before inserting it, you could put the insert into [...]
View Answer
| April 19, 2013 2:28 PM
Database programming, Search string, SQL Database, VB .NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005
If you are getting errors with the code you posted, please provide the exact error messages or tell us what the problem with that code is. If this code is working but you want to add the necessary logic to check if the record already exists before inserting it, you could put the insert into [...]
View Answer
| April 19, 2013 2:28 PM
Database programming, Search string, SQL Database, VB .NET, VB.NET 2005, Visual Basic .NET, Visual Basic 2005
Owner ship change
What O/S are you talking about…? If you’re talking iSeries then you can do a CHGOBJOWN at any time… To name just one… ====================================================== CHGOBJOWN is the common command to change ownership of objects that are in the /QSYS.LIB (library) file system. You can also use CHGOWN for objects in other file systems as well [...]
View Answer
| November 10, 2009 1:48 AM
AS/400, Database
What O/S are you talking about…? If you’re talking iSeries then you can do a CHGOBJOWN at any time… To name just one… ====================================================== CHGOBJOWN is the common command to change ownership of objects that are in the /QSYS.LIB (library) file system. You can also use CHGOWN for objects in other file systems as well [...]
View Answer
| November 10, 2009 1:48 AM
AS/400, Database
Database Splitting
You could create a new copy of the database, then delete documents from each database as appropriate.
View Answer
| November 9, 2009 3:32 PM
Access Database, Database optimization, Lotus Domino
You could create a new copy of the database, then delete documents from each database as appropriate.
View Answer
| November 9, 2009 3:32 PM
Access Database, Database optimization, Lotus Domino
How to combine 2 linked Excel tables in access 2003 with same field names, using query?
For the linked table approach. Make a Union query in Access. Select EmployeeID, CustomerID, Address From LinkedTable1 Union All Select EmployeeID, CustomerID, Address From LinkedTable2 This should do what you are asking for. The All part of the union brings in records that might be the same in both tables. If it could happen that [...]
View Answer
| November 6, 2009 8:59 PM
Access 2003, Data management, Microsoft Access query
For the linked table approach. Make a Union query in Access. Select EmployeeID, CustomerID, Address From LinkedTable1 Union All Select EmployeeID, CustomerID, Address From LinkedTable2 This should do what you are asking for. The All part of the union brings in records that might be the same in both tables. If it could happen that [...]
View Answer
| November 6, 2009 8:59 PM
Access 2003, Data management, Microsoft Access query
RPGLE Flat File
The most common way to put an index (key) on a file is to define it in the source. e.g. A UNIQUE A R ITEMSR A ICITEM 20 COLHDG(‘Item #’) A IMANF 8S 0 COLHDG(‘Last Date Sold’) A K ICITEM So the 1st 20 characters (the item number) are the key in this example. Note [...]
View Answer
| November 5, 2009 3:51 PM
Flat files, RPGLE
The most common way to put an index (key) on a file is to define it in the source. e.g. A UNIQUE A R ITEMSR A ICITEM 20 COLHDG(‘Item #’) A IMANF 8S 0 COLHDG(‘Last Date Sold’) A K ICITEM So the 1st 20 characters (the item number) are the key in this example. Note [...]
View Answer
| November 5, 2009 3:51 PM
Flat files, RPGLE
Mysql syntax
Hi Ak1bo78. You cannot insert 4 values in a table of 3 columns. This is very basic, and that is why I suggested a couple of tutorials in <a href=”http://itknowledgeexchange.techtarget.com/itanswers/constraints-mysqltablesnullpkfk-etc/#comments”>your other question</a>.
View Answer
| November 4, 2009 10:22 PM
Data Tables, MySQL, tables
Hi Ak1bo78. You cannot insert 4 values in a table of 3 columns. This is very basic, and that is why I suggested a couple of tutorials in <a href=”http://itknowledgeexchange.techtarget.com/itanswers/constraints-mysqltablesnullpkfk-etc/#comments”>your other question</a>.
View Answer
| November 4, 2009 10:22 PM
Data Tables, MySQL, tables
hi
The field names for the file (xxxx/AIR) are automatically declared to the CL (I am assuming that they are S and USER) If they are then just remove the DCL statements for these and it should work. If they are not then just prefix the actual names with & and use them instead. ======================================================== First, [...]
View Answer
| November 4, 2009 6:46 AM
AS/400, Database
The field names for the file (xxxx/AIR) are automatically declared to the CL (I am assuming that they are S and USER) If they are then just remove the DCL statements for these and it should work. If they are not then just prefix the actual names with & and use them instead. ======================================================== First, [...]
View Answer
| November 4, 2009 6:46 AM
AS/400, Database
FTP transfer from iSeries to PC workstation
I did a search on Google http://www.google.com/search?hl=en&lr=&q=as%2F400+ftp+pc and the first hit gives information on a book that tells you how to do just that. ========================================================== There are about 3.5 million google hits for [ftp message 550]. Looking at just a couple (e.g., <a href=”http://support.ipswitch.com/kb/WS-20000817-DM02.htm”>from WS_FTP</a>, <a href=”http://forum.filezilla-project.org/viewtopic.php?f=2&t=8596″>or from a FileZilla forum</a>) makes fairly clear that [...]
View Answer
| November 4, 2009 6:35 AM
AS/400, Database, Development, Network management software, Networking, Performance management, Remote management
I did a search on Google http://www.google.com/search?hl=en&lr=&q=as%2F400+ftp+pc and the first hit gives information on a book that tells you how to do just that. ========================================================== There are about 3.5 million google hits for [ftp message 550]. Looking at just a couple (e.g., <a href=”http://support.ipswitch.com/kb/WS-20000817-DM02.htm”>from WS_FTP</a>, <a href=”http://forum.filezilla-project.org/viewtopic.php?f=2&t=8596″>or from a FileZilla forum</a>) makes fairly clear that [...]
View Answer
| November 4, 2009 6:35 AM
AS/400, Database, Development, Network management software, Networking, Performance management, Remote management
SQL Table Join when the name of a column in Table1 equals the value of a column in Table2
I had the same question and could not easily find any answers. Here is what I came up with. The sysobjects table stores each table name with a type = ‘u’ The syscolumns table stores the column name for each table. Each of these tables shares an ID column, which you can use to join [...]
View Answer
| November 3, 2009 12:20 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL
I had the same question and could not easily find any answers. Here is what I came up with. The sysobjects table stores each table name with a type = ‘u’ The syscolumns table stores the column name for each table. Each of these tables shares an ID column, which you can use to join [...]
View Answer
| November 3, 2009 12:20 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL
Equivalent of a Application MAKE file on AS400
This might be of some help. It is one of the make files for a combined language (RPG and C) for an application by Giuseppe Costagliola. Maybe it will be of some help. SAY “========================================” SAY ‘Initialise fax decoder tables’ SAY “========================================” /* source files directory */ SRCDIR = ‘/pdf/libtiff-3.7.2/’ “CD /” “CD DIR(&SRCDIR)” “CHGJOB [...]
View Answer
| November 1, 2009 10:37 AM
AS/400, Database, Development
This might be of some help. It is one of the make files for a combined language (RPG and C) for an application by Giuseppe Costagliola. Maybe it will be of some help. SAY “========================================” SAY ‘Initialise fax decoder tables’ SAY “========================================” /* source files directory */ SRCDIR = ‘/pdf/libtiff-3.7.2/’ “CD /” “CD DIR(&SRCDIR)” “CHGJOB [...]
View Answer
| November 1, 2009 10:37 AM
AS/400, Database, Development
DB2 UDB for iSeries: Using CPYTOIMPF to trim blanks
We recently got this suggestion from a reader: “You could try explicitly specifying: RCDDLM(*CRLF) in your CpyToImpF command. It works for me we’re running OS/400 V5R2.” – Michelle ===================================================== If the field being transferred is a CHAR field, then trailing spaces is correct and they should not be truncated. If the field is VARCHAR, then [...]
View Answer
| November 1, 2009 9:19 AM
AS/400, Database, DB2, Oracle
We recently got this suggestion from a reader: “You could try explicitly specifying: RCDDLM(*CRLF) in your CpyToImpF command. It works for me we’re running OS/400 V5R2.” – Michelle ===================================================== If the field being transferred is a CHAR field, then trailing spaces is correct and they should not be truncated. If the field is VARCHAR, then [...]
View Answer
| November 1, 2009 9:19 AM
AS/400, Database, DB2, Oracle
CPYTOPCD filename length limitation
The limit of up to 8 chars and up to 3 chars extension applies to all folders and documents in QDLS. This is the only area of the IFS that the CPYTOPCD command will access. You can use COPYTOSTMF to copy a database file to other areas of the IFS as an ASCII text file, [...]
View Answer
| October 31, 2009 9:54 AM
AS/400, Database, DB2, Development, Oracle, Platform Issues
The limit of up to 8 chars and up to 3 chars extension applies to all folders and documents in QDLS. This is the only area of the IFS that the CPYTOPCD command will access. You can use COPYTOSTMF to copy a database file to other areas of the IFS as an ASCII text file, [...]
View Answer
| October 31, 2009 9:54 AM
AS/400, Database, DB2, Development, Oracle, Platform Issues
QMF issue
Try adding OVERRIDING SYSTEM VALUE here: <pre>INSERT INTO destination table OVERRIDING SYSTEM VALUE SELECT * FROM origin table </pre> Without knowing more than what you show, it’s hard to be about exact syntax or even if it’s appropriate. There’s no way to be sure that the schemas match up between QMF and interactive SQL, nor [...]
View Answer
| October 31, 2009 1:40 AM
AS/400 DB2, QMF, Query Management Facility, SQL
Try adding OVERRIDING SYSTEM VALUE here: <pre>INSERT INTO destination table OVERRIDING SYSTEM VALUE SELECT * FROM origin table </pre> Without knowing more than what you show, it’s hard to be about exact syntax or even if it’s appropriate. There’s no way to be sure that the schemas match up between QMF and interactive SQL, nor [...]
View Answer
| October 31, 2009 1:40 AM
AS/400 DB2, QMF, Query Management Facility, SQL
How to convert LONG to CLOB or to VARCHAR type in select statement
Have you tried to_string()?
View Answer
| October 30, 2009 10:29 PM
CLOB, Conversion, DataType, Long, Oracle, PL/SQL, SQL
Have you tried to_string()?
View Answer
| October 30, 2009 10:29 PM
CLOB, Conversion, DataType, Long, Oracle, PL/SQL, SQL
