Store Procedures, SQL statements
For efficiency, you want to try to do this all in a single query, without variables and IFs. Don’t return CRLFs to Crystal. Let Crystal do the formatting. Process as follows: SELECT CASE WHEN current.address IS NULL THEN mailing.address ELSE current.address END address, CASE WHEN current.address IS NULL THEN mailing.city ELSE current.city END city, CASE [...]
View Answer
| September 14, 2006 9:47 PM
Crystal Reports, Microsoft Windows, SQL Server
For efficiency, you want to try to do this all in a single query, without variables and IFs. Don’t return CRLFs to Crystal. Let Crystal do the formatting. Process as follows: SELECT CASE WHEN current.address IS NULL THEN mailing.address ELSE current.address END address, CASE WHEN current.address IS NULL THEN mailing.city ELSE current.city END city, CASE [...]
View Answer
| September 14, 2006 9:47 PM
Crystal Reports, Microsoft Windows, SQL Server
CLOB and VARCHAR2
I would suggest you pose this question on the asktom site. Tom Kyte would be an excellent resource (from Oracle) to address this question. He was at the PHLOUG meeting last night and shared some excellent tips on 10g R1 & 2 of the database. http://asktom.oracle.com
View Answer
| September 14, 2006 6:43 AM
Database, DB2, Oracle
I would suggest you pose this question on the asktom site. Tom Kyte would be an excellent resource (from Oracle) to address this question. He was at the PHLOUG meeting last night and shared some excellent tips on 10g R1 & 2 of the database. http://asktom.oracle.com
View Answer
| September 14, 2006 6:43 AM
Database, DB2, Oracle
Installing Oracle 9i on Windows XP
You probably have a previous installation of Oracle that has not been removed, or a partial installation that you have to manually remove. backup your system, Make sure that Oracle is uninstalled, manually delete all directories created for Oracle, edit the environment variables to remove Oracle entries, edit the system registry to remove all Oracle [...]
View Answer
| September 13, 2006 10:45 AM
Database, DB2, Oracle
You probably have a previous installation of Oracle that has not been removed, or a partial installation that you have to manually remove. backup your system, Make sure that Oracle is uninstalled, manually delete all directories created for Oracle, edit the environment variables to remove Oracle entries, edit the system registry to remove all Oracle [...]
View Answer
| September 13, 2006 10:45 AM
Database, DB2, Oracle
Changing Server Name Where ORACLE is Loaded
Good morning, Sam. Well, it may not be quite that straight forward. Part will depend on the version of Oracle you’re using, which type(s) of SQL authentication, which platform you’re on, which modules you may have implemented (Apps, RAC, etc.) and lastly, your backup solution. (I’m probably missing some, but this is all I can [...]
View Answer
| September 13, 2006 8:52 AM
Database, DB2, Oracle
Good morning, Sam. Well, it may not be quite that straight forward. Part will depend on the version of Oracle you’re using, which type(s) of SQL authentication, which platform you’re on, which modules you may have implemented (Apps, RAC, etc.) and lastly, your backup solution. (I’m probably missing some, but this is all I can [...]
View Answer
| September 13, 2006 8:52 AM
Database, DB2, Oracle
please solve this query
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 13, 2013 5:08 AM
Database, DB2, Oracle, Oracle development, SQL
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 13, 2013 5:08 AM
Database, DB2, Oracle, Oracle development, SQL
Uploading a file from a USB up to Mainframe & re-generating a PDS
If you’re trying to upload to a flat file that already exist the system won’t override it automatically. You have to delete the flat file before uploading if you changed the record length.
View Answer
| August 30, 2006 11:17 AM
390, DB2, Mainframe
If you’re trying to upload to a flat file that already exist the system won’t override it automatically. You have to delete the flat file before uploading if you changed the record length.
View Answer
| August 30, 2006 11:17 AM
390, DB2, Mainframe
need help in vb code
You could make this work right in the SQL statement: select id, @res:= case when price > @previous then 1 when price < @previous then 0 else if(@res is not NULL,@res,0 ) end as res, @previous as last_price, @previous:=price as this_price from tt; – end sql Produces: id res last_price this_price 1 1 905 905 [...]
View Answer
| August 24, 2006 12:58 AM
Database, DB2, Oracle
You could make this work right in the SQL statement: select id, @res:= case when price > @previous then 1 when price < @previous then 0 else if(@res is not NULL,@res,0 ) end as res, @previous as last_price, @previous:=price as this_price from tt; – end sql Produces: id res last_price this_price 1 1 905 905 [...]
View Answer
| August 24, 2006 12:58 AM
Database, DB2, Oracle
Microsoft Access Query Question
To show several authors for one paper you could group your report by paper. Place the paper in the group header and the author name in the group details. For your second question, you can pull in all resumes for one person by creating a report that utilizes a parameter. Ask for the name or [...]
View Answer
| August 21, 2006 11:26 AM
Database, DB2, Oracle
To show several authors for one paper you could group your report by paper. Place the paper in the group header and the author name in the group details. For your second question, you can pull in all resumes for one person by creating a report that utilizes a parameter. Ask for the name or [...]
View Answer
| August 21, 2006 11:26 AM
Database, DB2, Oracle
Oracle Data Guard Replication between SAN and NAS
Hi…. have a look here: http://www.oracle.com/technology/deploy/availability/htdocs/DataGuardRemoteMirroring.html As it is no block-level-based replication it makes no difference if the storage is SAN or NAS. You can mix NAS on DR-site with SAN at production side. regards, volker
View Answer
| August 21, 2006 7:16 AM
Data Replication, NAS, Oracle Data Guard, Oracle database security, SAN
Hi…. have a look here: http://www.oracle.com/technology/deploy/availability/htdocs/DataGuardRemoteMirroring.html As it is no block-level-based replication it makes no difference if the storage is SAN or NAS. You can mix NAS on DR-site with SAN at production side. regards, volker
View Answer
| August 21, 2006 7:16 AM
Data Replication, NAS, Oracle Data Guard, Oracle database security, SAN
Problems sending specific attachments
.tif files are generally quite large and may be to large for your server. To remedy this have your IT increase the size of out-going files or change the the extention to .doc. This should be the answer. I have had this problem with large photo and vidio files. It is best to increase the [...]
View Answer
| August 8, 2006 8:37 PM
Development, E-business, Exchange, Microsoft Office, Software
.tif files are generally quite large and may be to large for your server. To remedy this have your IT increase the size of out-going files or change the the extention to .doc. This should be the answer. I have had this problem with large photo and vidio files. It is best to increase the [...]
View Answer
| August 8, 2006 8:37 PM
Development, E-business, Exchange, Microsoft Office, Software
terminal server and gpo
I have been using a program called ScriptLogic that addresses what you wish to accomplish. I am able to set up desktops, outlook settings and other profile type settings that you can customize by user, groups, and even the type of login source (OS, workstation, server, etc… ) Check it out at ScriptLogic.com. I am [...]
View Answer
| August 6, 2006 9:49 AM
Access control, Application security, backdoors, Biometrics, Brightmail, Browsers, Business/IT alignment, Career development, CipherTrust, ClearSwift, Compliance, configuration, CRM, Current threats, Data analysis, Database, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, McAfee, MessageLabs, Network security, Outsourcing, Partner facing, patching, PEN testing, Platform Security, Policies, Postini, Project management, provisioning, Risk management, Rockliffe, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SSL/TLS, SurfControl, Symantec, TrendMicro, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
I have been using a program called ScriptLogic that addresses what you wish to accomplish. I am able to set up desktops, outlook settings and other profile type settings that you can customize by user, groups, and even the type of login source (OS, workstation, server, etc… ) Check it out at ScriptLogic.com. I am [...]
View Answer
| August 6, 2006 9:49 AM
Access control, Application security, backdoors, Biometrics, Brightmail, Browsers, Business/IT alignment, Career development, CipherTrust, ClearSwift, Compliance, configuration, CRM, Current threats, Data analysis, Database, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, McAfee, MessageLabs, Network security, Outsourcing, Partner facing, patching, PEN testing, Platform Security, Policies, Postini, Project management, provisioning, Risk management, Rockliffe, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SSL/TLS, SurfControl, Symantec, TrendMicro, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
DB2 Stored Procedure V4R4 without ILE C/400
You have to install ILE C/400. You are trying to implement functionality that does not exist in your old system. The only solution we have found that works reliably is for the remote server to call an SQL stored procedure. RPG and CL do not return result sets. You can go back to FTPing batch [...]
View Answer
| August 4, 2006 11:20 AM
AS/400, CLP, Database, DB2, DB2 Universal Database, Oracle, SQL, SQL Server
You have to install ILE C/400. You are trying to implement functionality that does not exist in your old system. The only solution we have found that works reliably is for the remote server to call an SQL stored procedure. RPG and CL do not return result sets. You can go back to FTPing batch [...]
View Answer
| August 4, 2006 11:20 AM
AS/400, CLP, Database, DB2, DB2 Universal Database, Oracle, SQL, SQL Server
pl/sql ref cursor question
To give a vague answer to a vague question, probably. It depends, to a large extent, on what type of resultset you’re starting with. Check these out for more details. http://www.samspublishing.com/articles/article.asp?p=26251&seqNum=7&rl=1 http://www.csee.umbc.edu/help/oracle8/java.815/a64685/oraext3.htm
View Answer
| August 2, 2006 11:57 AM
Database, DB2, DB2 Universal Database, Oracle, SQL
To give a vague answer to a vague question, probably. It depends, to a large extent, on what type of resultset you’re starting with. Check these out for more details. http://www.samspublishing.com/articles/article.asp?p=26251&seqNum=7&rl=1 http://www.csee.umbc.edu/help/oracle8/java.815/a64685/oraext3.htm
View Answer
| August 2, 2006 11:57 AM
Database, DB2, DB2 Universal Database, Oracle, SQL
Oracle Error Message ORA-01652
the user you are using to connect to the database with crystal report has its temporary tablespace set to SYSTEM change that ASAP and any other user who also has its temporary tablespace set to SYSTEM change them so that they use the real temporary tablespace which is probably TEMP “ALTER USER username TEMPORARY TABLESPACE [...]
View Answer
| August 2, 2006 7:58 AM
Development, ERP, Networking, Storage, Web development tools
the user you are using to connect to the database with crystal report has its temporary tablespace set to SYSTEM change that ASAP and any other user who also has its temporary tablespace set to SYSTEM change them so that they use the real temporary tablespace which is probably TEMP “ALTER USER username TEMPORARY TABLESPACE [...]
View Answer
| August 2, 2006 7:58 AM
Development, ERP, Networking, Storage, Web development tools
passing variables………………
What will happen is that the data at the address of A in the calling program will be mapped by the data description of C in the LINKAGE SECTION, the data at the address of B will be mapped to the A description and the data at C will be mapped to the B description. [...]
View Answer
| July 20, 2006 4:47 AM
390, DB2, Mainframe, zSeries
What will happen is that the data at the address of A in the calling program will be mapped by the data description of C in the LINKAGE SECTION, the data at the address of B will be mapped to the A description and the data at C will be mapped to the B description. [...]
View Answer
| July 20, 2006 4:47 AM
390, DB2, Mainframe, zSeries
Oracle Application or Database on its own server.
Do you have a performance problem ? Have you measured anything to determine what the cause of performance problem is ? Seperate or faster servers only help when there’s a CPU bottleneck. Ken
View Answer
| July 13, 2006 9:43 AM
Database, DB2, Oracle, Performance/Tuning, Windows
Do you have a performance problem ? Have you measured anything to determine what the cause of performance problem is ? Seperate or faster servers only help when there’s a CPU bottleneck. Ken
View Answer
| July 13, 2006 9:43 AM
Database, DB2, Oracle, Performance/Tuning, Windows
Running a script at specified runtime
Hi Columbus. The DBMS_JOB package should do the trick. See documentation on Oracle Supplied PL/SQL Packages and Types Reference for details on parameter requirements. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/jobq.htm#9499
View Answer
| July 11, 2006 10:59 AM
Architecture/Design, Availability, Backup & recovery, Business Intelligence, Data/Application Integration, E-Business Suite, Installation, Migration, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows
Hi Columbus. The DBMS_JOB package should do the trick. See documentation on Oracle Supplied PL/SQL Packages and Types Reference for details on parameter requirements. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/jobq.htm#9499
View Answer
| July 11, 2006 10:59 AM
Architecture/Design, Availability, Backup & recovery, Business Intelligence, Data/Application Integration, E-Business Suite, Installation, Migration, Oracle, Oracle 9i, Oracle administration, Oracle Business Applications, Oracle Database Versions, Oracle development, Performance/Tuning, Security, SQL, Windows
problem while accessing a Temporary dataset
Assuming you are running the job by yourself and not using something like CA7 to run the job, you will have to “RESTART” at the job step that creates the temp data set. Because once the original job terminated the temp data set is gone, you will have to recreate it. On the job card [...]
View Answer
| July 10, 2006 11:45 AM
390, DB2, Mainframe, zSeries
Assuming you are running the job by yourself and not using something like CA7 to run the job, you will have to “RESTART” at the job step that creates the temp data set. Because once the original job terminated the temp data set is gone, you will have to recreate it. On the job card [...]
View Answer
| July 10, 2006 11:45 AM
390, DB2, Mainframe, zSeries
Can’t login as Administrator
You now have to log in as Domain Administrator. Put the PC in the domain and log in as Domain administrator. You have to first pre-stage the server, then from a command prompt on another member server or domain controller, type nltest /server:name of your server.your domain/trusted_domains. Hope that helps Thuso
View Answer
| June 28, 2006 8:27 AM
Backup & recovery, Cabling, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, Ecommerce applications, Enterprise Desktop, Exchange, Hardware, Hewlett-Packard, Hubs, Instant Messaging, Lotus Domino, Management, Microsoft Systems Management Server, Microsoft Windows, Network management software, Networking, Networking services, Oracle, OS, PC/Windows Connectivity, Power management, Routers, Security, Servers, Software, SQL Server, Switches, Systems management software, Tech support, Training
You now have to log in as Domain Administrator. Put the PC in the domain and log in as Domain administrator. You have to first pre-stage the server, then from a command prompt on another member server or domain controller, type nltest /server:name of your server.your domain/trusted_domains. Hope that helps Thuso
View Answer
| June 28, 2006 8:27 AM
Backup & recovery, Cabling, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, Ecommerce applications, Enterprise Desktop, Exchange, Hardware, Hewlett-Packard, Hubs, Instant Messaging, Lotus Domino, Management, Microsoft Systems Management Server, Microsoft Windows, Network management software, Networking, Networking services, Oracle, OS, PC/Windows Connectivity, Power management, Routers, Security, Servers, Software, SQL Server, Switches, Systems management software, Tech support, Training
