Can you find out the name of the job calling a REXX program?
I am using REXX in TSO, and I would like to get information about the Batch job that called the REXX. I was hoping to get the Job name and the job number, but I can’t find anything. I’ve looked in the MVSVAR() and SYSVAR() functions, which is where I thought it’d be available, but [...]
Answer Question
| March 11, 2009 4:07 PM
IKJEFT01, MVSVAR, REXX, TSO
I am using REXX in TSO, and I would like to get information about the Batch job that called the REXX. I was hoping to get the Job name and the job number, but I can’t find anything. I’ve looked in the MVSVAR() and SYSVAR() functions, which is where I thought it’d be available, but [...]
Answer Question
| March 11, 2009 4:07 PM
IKJEFT01, MVSVAR, REXX, TSO
tell me why I’m getting the message “The multi-part identifier “134062-DB1.netFORUMSTaging.dbo.Individual.individualKey” could not be bound”
I’m trying to process this SQL statement select cxa_cst_key, cxa_key, cxa_key from [134062-DB1].netFORUMSTaging.dbo.Individual LEFT JOIN dbo.co_customer_x_address ON [134062-DB1].netFORUMSTaging.dbo.Individual.individualKey = co_customer_x_address.cxa_cst_key where delete_flag = 0 and source not in (‘MIBNOM1′,’MIBNOM2′) order by add_date asc But I keep getting an error message PLEASE HELP
Answer Question
| March 7, 2009 3:36 PM
SQL, SQL error messages, SQL Statement Syntax Errors, SQL statements
I’m trying to process this SQL statement select cxa_cst_key, cxa_key, cxa_key from [134062-DB1].netFORUMSTaging.dbo.Individual LEFT JOIN dbo.co_customer_x_address ON [134062-DB1].netFORUMSTaging.dbo.Individual.individualKey = co_customer_x_address.cxa_cst_key where delete_flag = 0 and source not in (‘MIBNOM1′,’MIBNOM2′) order by add_date asc But I keep getting an error message PLEASE HELP
Answer Question
| March 7, 2009 3:36 PM
SQL, SQL error messages, SQL Statement Syntax Errors, SQL statements
DCOM vs. OLE Explanation
What is DCOM? How is it different from OLE ?
Answer Question
| March 9, 2009 12:34 PM
DCOM, Distributed Component Object Model, Object Linking and Embedding, OLE
What is DCOM? How is it different from OLE ?
Answer Question
| March 9, 2009 12:34 PM
DCOM, Distributed Component Object Model, Object Linking and Embedding, OLE
A real-world C++ problem
A Real world Problem: This is a business rule of a bank that the Balance of customer must always be Positive, Further that it is also a business rule that a customer can not withdraw amount greater than his/her current balance. Question statement You are required to write a C++ program to solve this real [...]
Answer Question
| June 25, 2011 6:01 AM
C, OOPS, Software development
A Real world Problem: This is a business rule of a bank that the Balance of customer must always be Positive, Further that it is also a business rule that a customer can not withdraw amount greater than his/her current balance. Question statement You are required to write a C++ program to solve this real [...]
Answer Question
| June 25, 2011 6:01 AM
C, OOPS, Software development
Crystal Reports XI – Showing records when setting criteria
Goal: To show all customer orders. Along with those orders, I want to show all related notes on the progress for filling those orders. Problem: Some orders have no notes. When I set the criteria to show all orders and to show the notes, only orders with notes now appear in the report. Question: Is [...]
Answer Question
| March 6, 2009 11:42 PM
Crystal Reports, Crystal Reports XI, SQL
Goal: To show all customer orders. Along with those orders, I want to show all related notes on the progress for filling those orders. Problem: Some orders have no notes. When I set the criteria to show all orders and to show the notes, only orders with notes now appear in the report. Question: Is [...]
Answer Question
| March 6, 2009 11:42 PM
Crystal Reports, Crystal Reports XI, SQL
Finding the average of a data type on a SQL Server
I am trying to figure how to find the average of the data type datetime on my SQL Server. This is my code: SELECT CONVERT(varchar, Tanggal_Produksi, 3) AS Tanggal_Produksi, Target, Actual, Balance, CONVERT(varchar, Waktu_Proses_Awal, 8) AS Waktu_Proses_Awal, CONVERT(varchar, Waktu_Proses_Akhir, 8) AS Waktu_Proses_Akhir, CONVERT(varchar, Waktu_Proses_Akhir - Waktu_Proses_Awal, 8) AS Waktu_Proses, Bulan, Tahun FROM dbo.Histori_Produksi This is [...]
Answer Question
| March 5, 2009 8:25 PM
Data Types, DateTime, SQL Server, SQL Server DateTime, SQL Server errors
I am trying to figure how to find the average of the data type datetime on my SQL Server. This is my code: SELECT CONVERT(varchar, Tanggal_Produksi, 3) AS Tanggal_Produksi, Target, Actual, Balance, CONVERT(varchar, Waktu_Proses_Awal, 8) AS Waktu_Proses_Awal, CONVERT(varchar, Waktu_Proses_Akhir, 8) AS Waktu_Proses_Akhir, CONVERT(varchar, Waktu_Proses_Akhir - Waktu_Proses_Awal, 8) AS Waktu_Proses, Bulan, Tahun FROM dbo.Histori_Produksi This is [...]
Answer Question
| March 5, 2009 8:25 PM
Data Types, DateTime, SQL Server, SQL Server DateTime, SQL Server errors
double quotes with InStr method
how to identify a string with double quotes using the InStr method in vb
Answer Question
| March 5, 2009 6:11 PM
InStr function
how to identify a string with double quotes using the InStr method in vb
Answer Question
| March 5, 2009 6:11 PM
InStr function
Event fires for all collection members when one member triggers?
I have a usercontrol that contains a collection as a list(of <custom class>). Within the collection class for this usercontrol I have a shared event that is raised when a collection member is added to the class. Within the usercontrol class I have an event that is triggered when the collection class’ member added event [...]
Answer Question
| March 5, 2009 6:08 PM
VB.NET, VB.NET 2008, VB.NET User Control
I have a usercontrol that contains a collection as a list(of <custom class>). Within the collection class for this usercontrol I have a shared event that is raised when a collection member is added to the class. Within the usercontrol class I have an event that is triggered when the collection class’ member added event [...]
Answer Question
| March 5, 2009 6:08 PM
VB.NET, VB.NET 2008, VB.NET User Control
Join our ITKnowledgeExchange.com LinkedIn group
We have created an ITKnowledgeExchange.com LinkedIn Group If you are a member of LinkedIn come and join the group. You will be able to continue the discussion or post questions that we will post onto the site. Thanks Sean Community Manager
Answer Question
| November 13, 2009 4:19 PM
AS/400, CIO, Database, DataCenter, Development, Exchange 2003, Linux, Lotus Domino, Mobile, Oracle, Security, SQL Server, Storage, Virtualization, VoIP, Windows
We have created an ITKnowledgeExchange.com LinkedIn Group If you are a member of LinkedIn come and join the group. You will be able to continue the discussion or post questions that we will post onto the site. Thanks Sean Community Manager
Answer Question
| November 13, 2009 4:19 PM
AS/400, CIO, Database, DataCenter, Development, Exchange 2003, Linux, Lotus Domino, Mobile, Oracle, Security, SQL Server, Storage, Virtualization, VoIP, Windows
Locking Forms in Access 2000
I am using access 2000. I have created a form based on a table filled with tons of information. This is a multi user form. At the end of all of the records a blank form is presented so that the multi users can enter their appropriate information. However, some of the user are going [...]
Answer Question
| March 5, 2009 2:24 PM
Access 2000, Access forms, Microsoft Acccess
I am using access 2000. I have created a form based on a table filled with tons of information. This is a multi user form. At the end of all of the records a blank form is presented so that the multi users can enter their appropriate information. However, some of the user are going [...]
Answer Question
| March 5, 2009 2:24 PM
Access 2000, Access forms, Microsoft Acccess
Summer course for SAP or .NET?
I m a 2nd yr MCA strudent from BBSR and want to do some summer course. i am looking for a good inistitution for any summer course. and this year i am planing for either .NET or SAP which will be adviseble for me? now i m learning JAVA. this year i m supposed to [...]
Answer Question
| March 5, 2009 8:54 AM
.NET development, IT careers, IT education, SAP careers, SAP training
I m a 2nd yr MCA strudent from BBSR and want to do some summer course. i am looking for a good inistitution for any summer course. and this year i am planing for either .NET or SAP which will be adviseble for me? now i m learning JAVA. this year i m supposed to [...]
Answer Question
| March 5, 2009 8:54 AM
.NET development, IT careers, IT education, SAP careers, SAP training
Disable Form Controls in VB 2008 until selected
Beginning prog. student here… I have a form with multiple controls, and i want everything to be disabled except the datetimepicker. Once a date is selected, it should make the whole form usable. I’ve searched the web, and can’t find the right solutin. I found this sight, and hoping someone can help…Thanks!!
Answer Question
| March 5, 2009 8:35 AM
Active Selection, DateTimePicker, Focus and Selection, Inactive Selection, VB, VB 2008, VB controls, Visual Basic, Visual Basic 2008
Beginning prog. student here… I have a form with multiple controls, and i want everything to be disabled except the datetimepicker. Once a date is selected, it should make the whole form usable. I’ve searched the web, and can’t find the right solutin. I found this sight, and hoping someone can help…Thanks!!
Answer Question
| March 5, 2009 8:35 AM
Active Selection, DateTimePicker, Focus and Selection, Inactive Selection, VB, VB 2008, VB controls, Visual Basic, Visual Basic 2008
Alternative for LEFT OUTER JOIN
HI all, select code.batchno, detailA.batchfee , detailB.batchfee from Code code left outer join Detail detailA on (detailA.id= code.id) left outer join Detail detailB (detailB.id= code.id) where code.category = categoryA order by code.id I want an alternative for left outer join.. I cannot use left outer join for some purpose.. So i need an alternative for [...]
Answer Question
| July 28, 2010 5:23 AM
LEFT JOIN, LEFT OUTER JOIN statement, SQL Left Outer Join, SQL statements
HI all, select code.batchno, detailA.batchfee , detailB.batchfee from Code code left outer join Detail detailA on (detailA.id= code.id) left outer join Detail detailB (detailB.id= code.id) where code.category = categoryA order by code.id I want an alternative for left outer join.. I cannot use left outer join for some purpose.. So i need an alternative for [...]
Answer Question
| July 28, 2010 5:23 AM
LEFT JOIN, LEFT OUTER JOIN statement, SQL Left Outer Join, SQL statements
New Web Service Project
Hi, Currently an iSeries job runs every 10 minutes where, at the back end, a file is read (more than 400 fields), a pipe delimited file is created and FTP’d to an outside location. Volume would normally be low but intermittently there could be a spike. I need to replace the FTP process with a [...]
Answer Question
| March 6, 2009 10:05 PM
AS/400 development, AS/400 jobs, FTP, iSeries, Java, V5R4, Web development, Web Services Standards, WebSphere, XML
Hi, Currently an iSeries job runs every 10 minutes where, at the back end, a file is read (more than 400 fields), a pipe delimited file is created and FTP’d to an outside location. Volume would normally be low but intermittently there could be a spike. I need to replace the FTP process with a [...]
Answer Question
| March 6, 2009 10:05 PM
AS/400 development, AS/400 jobs, FTP, iSeries, Java, V5R4, Web development, Web Services Standards, WebSphere, XML
OracleClient
I am new to VB.Net, I am using VB.Net 2003 and Oracle 10g Express. In coding I enter Imports System.Data.OracleClient The system did not support. Why??
Answer Question
| March 5, 2009 8:14 PM
Oracle 10g, Oracle 10g Express, Oracle error messages, OracleClient, VB.NET, VB.NET 2003
I am new to VB.Net, I am using VB.Net 2003 and Oracle 10g Express. In coding I enter Imports System.Data.OracleClient The system did not support. Why??
Answer Question
| March 5, 2009 8:14 PM
Oracle 10g, Oracle 10g Express, Oracle error messages, OracleClient, VB.NET, VB.NET 2003
Excel 2002 Copy GetPivotDATA function
I have a number of different items that I need to extract from a pivot table. Can I copy the GETPIVOTDATA function? it seems to get stuck and return only the value from the first cell
Answer Question
| March 4, 2009 8:04 PM
Excel 2002, Excel functions, GetPivotData Function, Microsoft Excel, Pivot tables
I have a number of different items that I need to extract from a pivot table. Can I copy the GETPIVOTDATA function? it seems to get stuck and return only the value from the first cell
Answer Question
| March 4, 2009 8:04 PM
Excel 2002, Excel functions, GetPivotData Function, Microsoft Excel, Pivot tables
Setting up an Exchange mail server
How can I set up an Exchange mail server and client in a single PC? What are its basic requirements, and if you could, can you describe how a mail server functions?
Answer Question
| March 4, 2009 6:49 PM
Client-server, Exchange Server, Exchange server installation, Mail server
How can I set up an Exchange mail server and client in a single PC? What are its basic requirements, and if you could, can you describe how a mail server functions?
Answer Question
| March 4, 2009 6:49 PM
Client-server, Exchange Server, Exchange server installation, Mail server
MS Access Tools References…
Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library instead [...]
Answer Question
| March 4, 2009 5:38 PM
.NET, Microsoft Access, Microsoft Excel, Microsoft Office, VB.NET, VBA
Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library instead [...]
Answer Question
| March 4, 2009 5:38 PM
.NET, Microsoft Access, Microsoft Excel, Microsoft Office, VB.NET, VBA
XML parsing in COBOL on iseries
Can I get an example of how to parse XML document in ILE COBOL? I need both SAX and DOM parser examples.
Answer Question
| March 4, 2009 4:55 PM
COBOL, ILE COBOL, XML, XML in ILE cobol, XML Parsing
Can I get an example of how to parse XML document in ILE COBOL? I need both SAX and DOM parser examples.
Answer Question
| March 4, 2009 4:55 PM
COBOL, ILE COBOL, XML, XML in ILE cobol, XML Parsing
How do I display a clickable link from database in table using PHP?
I have a table and when I pull a clients info up I would like the web address to be able to be clicked to view web site. How would I code this in? Here is some of my code. $num_rows = mysql_num_rows($query); print “<b>Here is my Information on you. <br><br>E-Mail me with any changes.</b><P>”; [...]
Answer Question
| March 4, 2009 3:44 PM
Database, Display File, PHP, table
I have a table and when I pull a clients info up I would like the web address to be able to be clicked to view web site. How would I code this in? Here is some of my code. $num_rows = mysql_num_rows($query); print “<b>Here is my Information on you. <br><br>E-Mail me with any changes.</b><P>”; [...]
Answer Question
| March 4, 2009 3:44 PM
Database, Display File, PHP, table
