Using keyword IN in Dynamic SQL WHERE clause
Hi You would need to make use of the PREPARE statement to achieve this. For example if BankList contains ’0001, 0010, 0137′ you would use something like the following: Eval Text=’SELECT field1,field2 FROM file WHERE BankCode In(‘ + %Trim(BankList) + ‘)’ /Exec SQL PREPARE S1 FROM :Text /End-Exec /Exec SQL Declare C1 CURSOR FOR S1 [...]
View Answer
| November 29, 2004 11:47 AM
RPG, SQL
Hi You would need to make use of the PREPARE statement to achieve this. For example if BankList contains ’0001, 0010, 0137′ you would use something like the following: Eval Text=’SELECT field1,field2 FROM file WHERE BankCode In(‘ + %Trim(BankList) + ‘)’ /Exec SQL PREPARE S1 FROM :Text /End-Exec /Exec SQL Declare C1 CURSOR FOR S1 [...]
View Answer
| November 29, 2004 11:47 AM
RPG, SQL
OS 390
These days, it’s most likely DB2.
View Answer
| November 29, 2004 6:39 AM
DataCenter, Development
These days, it’s most likely DB2.
View Answer
| November 29, 2004 6:39 AM
DataCenter, Development
Monitor Internet Bandwidth
Use the ISA server built-in report utility, where you can define different reports to be run on f.ex. daily and/or monthly basis. ISA server will supply you with a number of reports including the one that you want. Tip: Run the report generator under a separate service account and not with your own user account, [...]
View Answer
| November 29, 2004 2:49 AM
Active Directory, Administration, Application management, Auditing, Availability, Backup, Backup & recovery, Bandwidth, Benchmarking, Bind, BroadVision, Business Objects, Call Centers, Clarify Inc., CLB, Client management, Clustering/High availability, Component Load Balancing, Content filtering, Corporate portal applications, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing/Business intelligence, Database Management Systems, DataCenter, Datacenter Server, DB2 administration, Desktop security, Desktops, DHCP, Distributed File System, DNS, E-business, E-mail applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, FAT and NTFS, Fault isolation, Firewalls, General Directories, Graphical User Interfaces, Handheld, Hardware, Help Desk, Information risk management, Integration/Connectivity, Intel servers, IT architecture, Knowledge management applications, Licensing, Lotus Domino, Mail protocols, Maintenance, Major Vendors, Microsoft Internet Information Server, Microsoft Windows, Monitoring, Netscape Mail, Network applications management, Network management software, Network monitoring, Network requirements, Network testing, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Operating systems, Outlook, PC/Windows Connectivity, Performance management, Performance/Tuning, Planning, Policies, POP3, Protocol analysis, Remote management, Reporting, ROI & cost justification, Routers, S/MIME, Security, Security management, Security products, Sendmail, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Services, Software, Software distribution, Software Quality Assurance, Spam, Storage, System monitoring, System utilities, Tech support, Technical support, Third-party services, Vendor support, Virus protection, Web services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows on Intel, Windows Server 2003
Use the ISA server built-in report utility, where you can define different reports to be run on f.ex. daily and/or monthly basis. ISA server will supply you with a number of reports including the one that you want. Tip: Run the report generator under a separate service account and not with your own user account, [...]
View Answer
| November 29, 2004 2:49 AM
Active Directory, Administration, Application management, Auditing, Availability, Backup, Backup & recovery, Bandwidth, Benchmarking, Bind, BroadVision, Business Objects, Call Centers, Clarify Inc., CLB, Client management, Clustering/High availability, Component Load Balancing, Content filtering, Corporate portal applications, Customer relationship management applications, Data analysis, Data center operations, Data mining/analysis, Data warehousing/Business intelligence, Database Management Systems, DataCenter, Datacenter Server, DB2 administration, Desktop security, Desktops, DHCP, Distributed File System, DNS, E-business, E-mail applications, ERP, Exchange, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, FAT and NTFS, Fault isolation, Firewalls, General Directories, Graphical User Interfaces, Handheld, Hardware, Help Desk, Information risk management, Integration/Connectivity, Intel servers, IT architecture, Knowledge management applications, Licensing, Lotus Domino, Mail protocols, Maintenance, Major Vendors, Microsoft Internet Information Server, Microsoft Windows, Monitoring, Netscape Mail, Network applications management, Network management software, Network monitoring, Network requirements, Network testing, Networking, Networking Equipment, Networking services, Office Applications, Operating system platforms, Operating systems, Outlook, PC/Windows Connectivity, Performance management, Performance/Tuning, Planning, Policies, POP3, Protocol analysis, Remote management, Reporting, ROI & cost justification, Routers, S/MIME, Security, Security management, Security products, Sendmail, Server consolidation, Server management, Server-based/Thin-client computing, Servers, Services, Software, Software distribution, Software Quality Assurance, Spam, Storage, System monitoring, System utilities, Tech support, Technical support, Third-party services, Vendor support, Virus protection, Web services, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance, Windows on Intel, Windows Server 2003
Oracle database authentication in VB
When you connect to the Oracle DB, you supply a userid and pwd. this is the user that is authenticated by Oracle and access privleges checked. If you are using a generic userid, then you have chosen to bypass Oracle security.
View Answer
| November 26, 2004 11:09 AM
Development, Oracle
When you connect to the Oracle DB, you supply a userid and pwd. this is the user that is authenticated by Oracle and access privleges checked. If you are using a generic userid, then you have chosen to bypass Oracle security.
View Answer
| November 26, 2004 11:09 AM
Development, Oracle
JavaScript Validation of Field Entry Against names.nsf
Is the reason you need java script is because your nsf file is on the web? ie Browser based? If not will Lotus Script or lotus formula do instead?
View Answer
| November 26, 2004 4:11 AM
Development, JavaScript, Lotus Domino
Is the reason you need java script is because your nsf file is on the web? ie Browser based? If not will Lotus Script or lotus formula do instead?
View Answer
| November 26, 2004 4:11 AM
Development, JavaScript, Lotus Domino
How to give focus to Notes Client from vbScript
there is no Notes functionality to do the trick. You have to use a Windows API function to get a handle to the Notes window and bring it to the front. Here is the function to get a handle to the window: Declare Function FindWindow Lib “user32″ Alias “FindWindowA” (Byval lpClassName&, Byval lpWindowName$) As Long [...]
View Answer
| November 25, 2004 1:54 AM
Development
there is no Notes functionality to do the trick. You have to use a Windows API function to get a handle to the Notes window and bring it to the front. Here is the function to get a handle to the window: Declare Function FindWindow Lib “user32″ Alias “FindWindowA” (Byval lpClassName&, Byval lpWindowName$) As Long [...]
View Answer
| November 25, 2004 1:54 AM
Development
Moving DNS outside
I am not sure what you mean when you say moving the DNS services outside? The DNS servers you have setup now will need to remain active as AD will not work without the internal DNS service. I suspect you know that already, that is why I am confused as to what you are asking.
View Answer
| November 24, 2004 8:47 AM
Active Directory, Adapters/Interfaces, Administration, AMD PC hardware, Arrays, Backup, Backup & recovery, BlackBerry, Computer Associates, Desktops, DHCP, Dial-up networking, Disk drives, DNS, E-mail applications, Exchange 2003, FAT and NTFS, Firewalls, Forensics, Gigabit ethernet, Handheld, Help Desk, Incident response, Installation, Intel PC hardware, Intel servers, Intrusion management, Layer 3-7 Switches, Mac hardware, Mac OS X, Microsoft Windows, MS-DOS, Network security, Networking, Networking Equipment, Networking services, Outlook, Overland Data, Palm OS, Performance/Tuning, RAID, Remote management, Servers, Storage servers, Switches, Tape drives/Libraries, Tech support, VPN, WatchGuard, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Mobile, Windows Server 2003, Windows XP, Wireless, Yahoo
I am not sure what you mean when you say moving the DNS services outside? The DNS servers you have setup now will need to remain active as AD will not work without the internal DNS service. I suspect you know that already, that is why I am confused as to what you are asking.
View Answer
| November 24, 2004 8:47 AM
Active Directory, Adapters/Interfaces, Administration, AMD PC hardware, Arrays, Backup, Backup & recovery, BlackBerry, Computer Associates, Desktops, DHCP, Dial-up networking, Disk drives, DNS, E-mail applications, Exchange 2003, FAT and NTFS, Firewalls, Forensics, Gigabit ethernet, Handheld, Help Desk, Incident response, Installation, Intel PC hardware, Intel servers, Intrusion management, Layer 3-7 Switches, Mac hardware, Mac OS X, Microsoft Windows, MS-DOS, Network security, Networking, Networking Equipment, Networking services, Outlook, Overland Data, Palm OS, Performance/Tuning, RAID, Remote management, Servers, Storage servers, Switches, Tape drives/Libraries, Tech support, VPN, WatchGuard, Windows, Windows 2000 desktop, Windows 2000 Server, Windows 95/98, Windows client administration and maintenance, Windows Mobile, Windows Server 2003, Windows XP, Wireless, Yahoo
ORA-03113 error while compiling Oracle packages
I have seen this error when your session times out. Check your session/user settings. Stefan
View Answer
| November 24, 2004 8:13 AM
Oracle, Oracle 8i, Oracle 9i, SQL, Standard Edition
I have seen this error when your session times out. Check your session/user settings. Stefan
View Answer
| November 24, 2004 8:13 AM
Oracle, Oracle 8i, Oracle 9i, SQL, Standard Edition
Change Management Software
We use Aldon/CMS (iSeries only solution). We have had very good experience with it. Intuitive interface for the most part. The Winders side of the shop still uses Source Safe <shudder>, so we have no experience with any REAL tools on that side of the aisle.
View Answer
| November 23, 2004 4:56 PM
Development, Lifecycle development, Project management, Sarbanes-Oxley Act, Software Quality Assurance
We use Aldon/CMS (iSeries only solution). We have had very good experience with it. Intuitive interface for the most part. The Winders side of the shop still uses Source Safe <shudder>, so we have no experience with any REAL tools on that side of the aisle.
View Answer
| November 23, 2004 4:56 PM
Development, Lifecycle development, Project management, Sarbanes-Oxley Act, Software Quality Assurance
Booting out users of a multi user database system
This is what I’d recommend. This is for SQL server, if you have another DBMS this will be slightly different. I’m assuming you want to automate this task. (1) let all your users know that scheduled maintenance begins at ?? time and give them advanced notice of the outage. (2) In SQL server, next you [...]
View Answer
| November 23, 2004 10:29 AM
Development
This is what I’d recommend. This is for SQL server, if you have another DBMS this will be slightly different. I’m assuming you want to automate this task. (1) let all your users know that scheduled maintenance begins at ?? time and give them advanced notice of the outage. (2) In SQL server, next you [...]
View Answer
| November 23, 2004 10:29 AM
Development
Installing Siebel 7.7 on a stand alone machine with DB2
Well, exactly. We have done it on WIN2003 servers . One for sibel 7.7 one for DB2 V81.6 Workgroup Edition. There is a IBM redbook on the subject. Sorry I do not remember the book number. One hazel we had was misc DB space/size parameter related. IBM recomend in general lager “numbers” than Siebel, but [...]
View Answer
| November 23, 2004 8:14 AM
Data analysis, DB2, Development, ERP, Hardware, Tech support
Well, exactly. We have done it on WIN2003 servers . One for sibel 7.7 one for DB2 V81.6 Workgroup Edition. There is a IBM redbook on the subject. Sorry I do not remember the book number. One hazel we had was misc DB space/size parameter related. IBM recomend in general lager “numbers” than Siebel, but [...]
View Answer
| November 23, 2004 8:14 AM
Data analysis, DB2, Development, ERP, Hardware, Tech support
Event viewer err Msg.
First off, check your default domain controller policy to sort out your incorrect SID. It’s most probably power users in the windows security settings. Static IPs won’t give you a problem unless you run DHCP as well and hand out the same IPs. Make sure subnet masks are correct. Your problem does look like an [...]
View Answer
| November 23, 2004 4:55 AM
802.11 networking equipment, Active Directory, Administration, Auditing, Biometrics, configuration, DataCenter, Digital certificates, DNS, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, Firewalls, Forensics, Help Desk, Identity & Access Management, Incident response, Installation, Intrusion management, Maintenance, Management, Microsoft Windows, Monitoring, Network security, Outlook, patching, PEN testing, Platform Security, provisioning, Security, Security tokens, Server management, Servers, Service and support, Services, Single sign-on, System monitoring, Tech support, Third-party services, VPN, vulnerability management, Windows 2000 Server, Windows Server 2003, WINS, Wireless
First off, check your default domain controller policy to sort out your incorrect SID. It’s most probably power users in the windows security settings. Static IPs won’t give you a problem unless you run DHCP as well and hand out the same IPs. Make sure subnet masks are correct. Your problem does look like an [...]
View Answer
| November 23, 2004 4:55 AM
802.11 networking equipment, Active Directory, Administration, Auditing, Biometrics, configuration, DataCenter, Digital certificates, DNS, Exchange 2000, Exchange 2003, Exchange 5.5, Exchange Server ActiveSync, Firewalls, Forensics, Help Desk, Identity & Access Management, Incident response, Installation, Intrusion management, Maintenance, Management, Microsoft Windows, Monitoring, Network security, Outlook, patching, PEN testing, Platform Security, provisioning, Security, Security tokens, Server management, Servers, Service and support, Services, Single sign-on, System monitoring, Tech support, Third-party services, VPN, vulnerability management, Windows 2000 Server, Windows Server 2003, WINS, Wireless
AS/400 Trigger programming
You probably have to set ALWREPCHG to *NO in your ADDPFTRG command. Regards
View Answer
| November 23, 2004 2:44 AM
AS/400, Development, Lifecycle development, RPG, Software testing
You probably have to set ALWREPCHG to *NO in your ADDPFTRG command. Regards
View Answer
| November 23, 2004 2:44 AM
AS/400, Development, Lifecycle development, RPG, Software testing
Certification in RPG
How long have you been coding? I was writing RPG III for 18 years and only wrote sporadically in RPG ILE until recently, self taught from the manuals. I managed to pass the RPG Developer Certification from there. You may just want to see where your knowledge is insufficient. I’m sorry that I don’t remember [...]
View Answer
| November 22, 2004 8:53 AM
Certifications, Development, RPG
How long have you been coding? I was writing RPG III for 18 years and only wrote sporadically in RPG ILE until recently, self taught from the manuals. I managed to pass the RPG Developer Certification from there. You may just want to see where your knowledge is insufficient. I’m sorry that I don’t remember [...]
View Answer
| November 22, 2004 8:53 AM
Certifications, Development, RPG
Project Review Methodology
Hi – have you checked out the RUP methodology by IBM? It’s popular within IT industries, and you can find out more about the concepts at the Rational website: http://www-128.ibm.com/developerworks/websphere/library/techarticles/0306_perks/perks2.html We involve the entire project team in a project implementation review process. This way you get an honest review of what went well and what [...]
View Answer
| November 21, 2004 6:24 PM
Project management
Hi – have you checked out the RUP methodology by IBM? It’s popular within IT industries, and you can find out more about the concepts at the Rational website: http://www-128.ibm.com/developerworks/websphere/library/techarticles/0306_perks/perks2.html We involve the entire project team in a project implementation review process. This way you get an honest review of what went well and what [...]
View Answer
| November 21, 2004 6:24 PM
Project management
Sql Server Linked Server to iSeries
Marco, Havn’t done anything with linked servers myself, but came across the info below when looking for something else recently. Even if it doesn’t help you directly I think would be worth posting your problem to. http://blog.benjolo.com/archives/2003/08/27/mysql-mssql-linked-tables-or-just-kill-me-now/
View Answer
| November 19, 2004 7:10 AM
AS/400, Database Management Systems, Development, Microsoft Windows, Networking, SQL Server, Tech support
Marco, Havn’t done anything with linked servers myself, but came across the info below when looking for something else recently. Even if it doesn’t help you directly I think would be worth posting your problem to. http://blog.benjolo.com/archives/2003/08/27/mysql-mssql-linked-tables-or-just-kill-me-now/
View Answer
| November 19, 2004 7:10 AM
AS/400, Database Management Systems, Development, Microsoft Windows, Networking, SQL Server, Tech support
Performance Tuninig of a Select Query.
Have you tried doing an Explain Plan on your query?
View Answer
| November 18, 2004 10:04 PM
Development, Oracle, SQL
Have you tried doing an Explain Plan on your query?
View Answer
| November 18, 2004 10:04 PM
Development, Oracle, SQL
Updat a dabase using CL
No, CL does not have the capability of updating database files. It is possible to indirectly update a file by creating a Query Manager Query and passing it parameters at run time.
View Answer
| November 17, 2004 10:15 AM
Development
No, CL does not have the capability of updating database files. It is possible to indirectly update a file by creating a Query Manager Query and passing it parameters at run time.
View Answer
| November 17, 2004 10:15 AM
Development
The WebSphere Webfacing Tool
The Web Facing function (5250 DDS to JSP) is a standard part of the WebSphere Design Studio Client. There is a great Redbook out on the process also as well as numerous books from 29th STreet press. This facility will easily handle all the conversion and JSP work for you without having to touch a [...]
View Answer
| November 16, 2004 10:15 AM
Development, E-business, Graphical User Interfaces, Hardware, i5, iSeries, Operating system platforms, OS/400, Programming Languages, Servers, Tech support, Web services, WebSphere Studio, Windows
The Web Facing function (5250 DDS to JSP) is a standard part of the WebSphere Design Studio Client. There is a great Redbook out on the process also as well as numerous books from 29th STreet press. This facility will easily handle all the conversion and JSP work for you without having to touch a [...]
View Answer
| November 16, 2004 10:15 AM
Development, E-business, Graphical User Interfaces, Hardware, i5, iSeries, Operating system platforms, OS/400, Programming Languages, Servers, Tech support, Web services, WebSphere Studio, Windows
DB2 SQL delete to purge Header/Detail records
Recommend you use TYPE date instead of TYPE integer for nDate. In your SQL, a current date of 15 Nov 2004 gives: 20041115 – 30 = 20041085 (not a valid date)
View Answer
| November 15, 2004 3:30 PM
DB2, SQL
Recommend you use TYPE date instead of TYPE integer for nDate. In your SQL, a current date of 15 Nov 2004 gives: 20041115 – 30 = 20041085 (not a valid date)
View Answer
| November 15, 2004 3:30 PM
DB2, SQL
