Daylight savings – Change in politics
Microsoft has posted an update to Windows XP that resolved this problem. They MAY also have updates for other Windows versions (I haven’t checked). Jay
View Answer
| November 25, 2006 7:09 AM
Database, DataCenter, DB2, Desktops, Hardware, Linux, Management, Microsoft Windows, Networking, Oracle, OS, Security, Servers, SQL Server
Microsoft has posted an update to Windows XP that resolved this problem. They MAY also have updates for other Windows versions (I haven’t checked). Jay
View Answer
| November 25, 2006 7:09 AM
Database, DataCenter, DB2, Desktops, Hardware, Linux, Management, Microsoft Windows, Networking, Oracle, OS, Security, Servers, SQL Server
Oracle SQL and compare date
Just subtract one date from the other and the number of days between will be calculated by Oracle. Magic!
View Answer
| April 18, 2013 6:40 AM
BPEL, Business Process Execution Language, Database, DB2, Oracle, Oracle 9i, SQL
Just subtract one date from the other and the number of days between will be calculated by Oracle. Magic!
View Answer
| April 18, 2013 6:40 AM
BPEL, Business Process Execution Language, Database, DB2, Oracle, Oracle 9i, SQL
Excel Spreadsheets
Try checking to see if the properties for auto refreshing the data when you open the workbook are set. This can be set to automatically open the required spreadsheet(s)/data file without user intervention. I use this to get data from the web automatically when I launch a workbook for epos data to be collated. I [...]
View Answer
| November 23, 2006 12:23 PM
Data analysis, Database, DataCenter, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server
Try checking to see if the properties for auto refreshing the data when you open the workbook are set. This can be set to automatically open the required spreadsheet(s)/data file without user intervention. I use this to get data from the web automatically when I launch a workbook for epos data to be collated. I [...]
View Answer
| November 23, 2006 12:23 PM
Data analysis, Database, DataCenter, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server
Using an array in embedded SQL in RPGLE
As far as I know, SQL has no way to subscript your host variable and therefore no way to reference an array element directly. I always move the array element into a work field, execute the SQL statement, and then put the work field back into the array element (if needed).
View Answer
| November 22, 2006 11:42 AM
Application development, DB2 Universal Database, Development, RPGLE, SQL
As far as I know, SQL has no way to subscript your host variable and therefore no way to reference an array element directly. I always move the array element into a work field, execute the SQL statement, and then put the work field back into the array element (if needed).
View Answer
| November 22, 2006 11:42 AM
Application development, DB2 Universal Database, Development, RPGLE, SQL
DB Migration from 8.1.7 to 10gR1
Think backwards. Leave 8i up as production and progress your changes to the 10g database, using 10g as parallel. Once you are assured that all transactions work, then convert finally to 10g and archive the old 8i database. Do not be too fast to make 10g production. Second question – best practices. Create a test [...]
View Answer
| November 15, 2006 2:46 PM
CRM, Database, DB2, Oracle
Think backwards. Leave 8i up as production and progress your changes to the 10g database, using 10g as parallel. Once you are assured that all transactions work, then convert finally to 10g and archive the old 8i database. Do not be too fast to make 10g production. Second question – best practices. Create a test [...]
View Answer
| November 15, 2006 2:46 PM
CRM, Database, DB2, Oracle
Oracle Parse – Instr
To get two results back, use two functions, a function that returns a composite object (such as a record), or a procedure with two OUT parameters. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
View Answer
| November 15, 2006 10:48 AM
Database, DB2, Oracle, SQL
To get two results back, use two functions, a function that returns a composite object (such as a record), or a procedure with two OUT parameters. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
View Answer
| November 15, 2006 10:48 AM
Database, DB2, Oracle, SQL
Conversion Project
As both your source and target data resides on the I-Series you shouldn’t have too much trouble. We have experience of replicating data between i-Series and MS-SQL using a product called Scribe Insight. This allows you to map source files and fields to target files and fields. This mapping process allows you to perform functions [...]
View Answer
| November 15, 2006 7:14 AM
Application development, AS/400, Data analysis, DB2 Universal Database
As both your source and target data resides on the I-Series you shouldn’t have too much trouble. We have experience of replicating data between i-Series and MS-SQL using a product called Scribe Insight. This allows you to map source files and fields to target files and fields. This mapping process allows you to perform functions [...]
View Answer
| November 15, 2006 7:14 AM
Application development, AS/400, Data analysis, DB2 Universal Database
SQL Errr
Do it this way: UPDATE amfLibT.morOut a SET opsTC = 40 WHERE opSeq<’0047′ AND opsTC=10 AND wkCtr=’INFO’ AND EXISTS( SELECT 1 FROM amfLibT.momAST b WHERE a.ordNo=b.ordNo AND b.fItem=’300.605.407.8′ AND b.oStat<>10) In some SQLs, instead of (for instance) “morOut a”, you need to code “morOut AS a”. The “1″ is just a place-holder. It doesn’t matter [...]
View Answer
| November 14, 2006 11:18 AM
AS/400, DB2 Universal Database
Do it this way: UPDATE amfLibT.morOut a SET opsTC = 40 WHERE opSeq<’0047′ AND opsTC=10 AND wkCtr=’INFO’ AND EXISTS( SELECT 1 FROM amfLibT.momAST b WHERE a.ordNo=b.ordNo AND b.fItem=’300.605.407.8′ AND b.oStat<>10) In some SQLs, instead of (for instance) “morOut a”, you need to code “morOut AS a”. The “1″ is just a place-holder. It doesn’t matter [...]
View Answer
| November 14, 2006 11:18 AM
AS/400, DB2 Universal Database
can strqmqry be run as remote command
I got it! Yes, it can be done this way. I finally decided to step through the proc again and my issue was when executing the command I was not properly quoting the variable. My initial presumption based on my research was that I did not need it… but I did. The example below required [...]
View Answer
| November 9, 2006 12:18 PM
Application development, AS/400, Backup & recovery, CLP, Data analysis, DB2 Universal Database, PC/Windows Connectivity, Printing
I got it! Yes, it can be done this way. I finally decided to step through the proc again and my issue was when executing the command I was not properly quoting the variable. My initial presumption based on my research was that I did not need it… but I did. The example below required [...]
View Answer
| November 9, 2006 12:18 PM
Application development, AS/400, Backup & recovery, CLP, Data analysis, DB2 Universal Database, PC/Windows Connectivity, Printing
Testing how long an SQL script will takfe to run
Test the scripts in a test environment (wiht small proportionally tables) and turn on the timing session parameter with “set timing on;” or capture the begining and the end of the execution whit a “spool command” or “set serveroutput on 10000; and the dbms_output package.” to printscreen the result.
View Answer
| November 8, 2006 3:12 PM
Database, DB2, Oracle
Test the scripts in a test environment (wiht small proportionally tables) and turn on the timing session parameter with “set timing on;” or capture the begining and the end of the execution whit a “spool command” or “set serveroutput on 10000; and the dbms_output package.” to printscreen the result.
View Answer
| November 8, 2006 3:12 PM
Database, DB2, Oracle
OPNQRYF’s MAPFLD
MAPFLD(@NEW ‘%max(A,B)’)
View Answer
| November 8, 2006 9:04 AM
Application development, AS/400, Data analysis, Database, DB2, DB2 Universal Database, IBM, IBM Marketing Sound Off, Oracle, RPGLE
MAPFLD(@NEW ‘%max(A,B)’)
View Answer
| November 8, 2006 9:04 AM
Application development, AS/400, Data analysis, Database, DB2, DB2 Universal Database, IBM, IBM Marketing Sound Off, Oracle, RPGLE
Blue Socket Gateway and Certificates
I would never, under any circumstances, buy equipment that has to sit outside the Firewall. The whole point to Wireless access is security. If you can’t follow standards, you go out of business. Sounds like these chumps need to close shop. There isn’t a single network out there I would risk on such a ridiculous [...]
View Answer
| November 8, 2006 7:43 AM
Access control, Active Directory, Application security, Browsers, Compliance, CRM, Database, Desktops, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Windows, Network security, Networking, OS, Policies, Risk management, Secure Coding, Security, Security Program Management, Servers, SQL Server, SSL/TLS, VPN, Web security, Wireless
I would never, under any circumstances, buy equipment that has to sit outside the Firewall. The whole point to Wireless access is security. If you can’t follow standards, you go out of business. Sounds like these chumps need to close shop. There isn’t a single network out there I would risk on such a ridiculous [...]
View Answer
| November 8, 2006 7:43 AM
Access control, Active Directory, Application security, Browsers, Compliance, CRM, Database, Desktops, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Windows, Network security, Networking, OS, Policies, Risk management, Secure Coding, Security, Security Program Management, Servers, SQL Server, SSL/TLS, VPN, Web security, Wireless
MS SQL Server 2000
You need public IP for that SQL server machine if your server is located behide firewall u need to config your firewall to redirect to SQL server machine with specific port that sql server use.
View Answer
| November 8, 2006 1:37 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development
You need public IP for that SQL server machine if your server is located behide firewall u need to config your firewall to redirect to SQL server machine with specific port that sql server use.
View Answer
| November 8, 2006 1:37 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development
How to prevent XSRF attacks
I saw in a posting on a different list that someone has written a plug-in to prevent CSRF or XSRF attacks. Kanatoko wrote: I wrote a small plugin for Guardian@JUMPERZ.NET(OSS WAF) to prevent CSRF attacks. – From Documentation – This plugin detects and prevents CSRF(Cross Site Request Forgery) attacks. This plugin detects CSRF attacks by [...]
View Answer
| November 6, 2006 9:12 AM
Access control, Application security, Browsers, Database, Encryption, Exchange, filtering, Instant Messaging, Secure Coding, Servers, SSL/TLS, Web security
I saw in a posting on a different list that someone has written a plug-in to prevent CSRF or XSRF attacks. Kanatoko wrote: I wrote a small plugin for Guardian@JUMPERZ.NET(OSS WAF) to prevent CSRF attacks. – From Documentation – This plugin detects and prevents CSRF(Cross Site Request Forgery) attacks. This plugin detects CSRF attacks by [...]
View Answer
| November 6, 2006 9:12 AM
Access control, Application security, Browsers, Database, Encryption, Exchange, filtering, Instant Messaging, Secure Coding, Servers, SSL/TLS, Web security
Creating DB2/400 Table Dynamically
You could do it using SQL to create the table. To run an SQL command, e.g. CREATE, from a CL program check out the RUNSQL utility at this link: http://www.as400pro.com/servlet/sql.tipView?key=159&category=SQL All the best Jonathan
View Answer
| November 3, 2006 7:16 AM
DB2 Universal Database
You could do it using SQL to create the table. To run an SQL command, e.g. CREATE, from a CL program check out the RUNSQL utility at this link: http://www.as400pro.com/servlet/sql.tipView?key=159&category=SQL All the best Jonathan
View Answer
| November 3, 2006 7:16 AM
DB2 Universal Database
SQL Stored procedure call via ODBC
The naming convention determines whether slash or dot will be used. Try using a slash instead. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
View Answer
| October 31, 2006 1:29 PM
DB2 Universal Database, PC/Windows Connectivity
The naming convention determines whether slash or dot will be used. Try using a slash instead. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
View Answer
| October 31, 2006 1:29 PM
DB2 Universal Database, PC/Windows Connectivity
security problem
The answer is simple. The company who owns the computer has the right to monitor all business conducted on that computer wheather it is business related or not. Most employees think that the pc belongs to them and the have the right to do with it as they please. The pc is there as a [...]
View Answer
| October 31, 2006 7:00 AM
Access control, Application security, backdoors, Backup & recovery, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Database, DataCenter, DataManagement, DB2, Desktop management applications, Development, DHCP, Digital certificates, Disaster Recovery, DNS, Ecommerce applications, Encryption, Enterprise Desktop, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intel, Interoperability, Intrusion management, LANDesk, Lotus Domino, McAfee, Microsoft Systems Management Server, Microsoft Windows, Mobile security, Network security, Networking, Networking services, Oracle, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Postini, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Software, Spam, Spyware, SSL/TLS, Symantec, Systems management software, Tech support, Trojans, Vector Networks, Viruses, VPN, vulnerability management, Web security, Wireless, worms
The answer is simple. The company who owns the computer has the right to monitor all business conducted on that computer wheather it is business related or not. Most employees think that the pc belongs to them and the have the right to do with it as they please. The pc is there as a [...]
View Answer
| October 31, 2006 7:00 AM
Access control, Application security, backdoors, Backup & recovery, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Database, DataCenter, DataManagement, DB2, Desktop management applications, Development, DHCP, Digital certificates, Disaster Recovery, DNS, Ecommerce applications, Encryption, Enterprise Desktop, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intel, Interoperability, Intrusion management, LANDesk, Lotus Domino, McAfee, Microsoft Systems Management Server, Microsoft Windows, Mobile security, Network security, Networking, Networking services, Oracle, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Postini, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Software, Spam, Spyware, SSL/TLS, Symantec, Systems management software, Tech support, Trojans, Vector Networks, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Isolation level… Join new JAVA development with old, outdated COBOL code…
How to handle isolation levels depends on which DBMS you’re using. DB2 most closely matches Cobol’s model. For instance, if you’re using DB2, you can control the level on a statement-by-statement basis, using WITH or FOR. Example: SELECT x FROM y WITH NC; SELECT a FROM b WITH RR; — Sheldon Linker (sol@linker.com) Linker Systems, [...]
View Answer
| October 30, 2006 2:27 PM
AS/400, DB2 Universal Database
How to handle isolation levels depends on which DBMS you’re using. DB2 most closely matches Cobol’s model. For instance, if you’re using DB2, you can control the level on a statement-by-statement basis, using WITH or FOR. Example: SELECT x FROM y WITH NC; SELECT a FROM b WITH RR; — Sheldon Linker (sol@linker.com) Linker Systems, [...]
View Answer
| October 30, 2006 2:27 PM
AS/400, DB2 Universal Database
Logical file to include only one of many matching records in secondaryu file
This sounds like an ideal case for a Join Logical file. Create a Join Logical file, joining the two files using all the common fields. Define the record format with all the fields that you want to use when you access this Join Logical. Good Luck!
View Answer
| October 25, 2006 4:54 PM
DB2 Universal Database, RPG, RPGLE
This sounds like an ideal case for a Join Logical file. Create a Join Logical file, joining the two files using all the common fields. Define the record format with all the fields that you want to use when you access this Join Logical. Good Luck!
View Answer
| October 25, 2006 4:54 PM
DB2 Universal Database, RPG, RPGLE
ODBC connections
you have to know what kind of database it is so you can pick the correct provider when creating an ODBC data source. Once you create the data source, you can use Access to open up that data source.
View Answer
| October 25, 2006 9:36 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
you have to know what kind of database it is so you can pick the correct provider when creating an ODBC data source. Once you create the data source, you can use Access to open up that data source.
View Answer
| October 25, 2006 9:36 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
