Search results for query: *

Apologies - I have been trying to find a Tek-Tips forum which deals with IBM SORT questions. Does anyone know of one? I would really appreciate any help if anyone does know. Or, even better, could anyone answer the following question; I have an input dataset which contains delimited fields. I...

Using Windows XP Professional, Internet Explorer 8, Talk21 E-Mail, occasionally get an E-Mail with embedded photographs that will not display. When accessing "Properties" - file type is shown as "HTTP with Privacy". How can I "decipher" these files ? If this is not the appropriate forum, I...

I have a COBOL/DB2 Program - ProgramA, which calls a sub-program COBOL/DB2 Program - ProgramB. both are compiled, linked, and bound using the same JCL, the only change is the program name. Obviously, ProgramB is compiled, linked and bound before ProgramA Program A does a "bit" of SQL - just...

I would like to INSERT INTO TABLE_A SELECT * FROM TABLE_B, but, put fixed values into the first three columns of the destination table, as follows; INSERT INTO TABLE_A VALUES ("VAL1", "VAL2", "VAL3", ((Select X From TABLE_B)) Where "X" is the remaining columns from TABLE_B. Obviously, this...

Is it possible to do the above in IBM MVs or Z/OS ? Specifically, I would like to do the following; SELECT * FROM ANY_TABLE WHERE ANY_COLUMN IN (Parm1, Parm2, etc). (Or any other construct that would do the required function) "Parm1", "Parm2" to be contained in an input dataset, as separate...

Does anyone know how I do the above ?

I have a signed input field, PIC 9(12)V9(6). I have no problem converting this to a leading and trailing zero suppressed field for example - Input - 000000000123.450000 Output 123.45 However, I do have a problem when it's signed. For instance, if I define the output as PIC Z(11)9.9(6)-, the...

The PC I use at work is maintained by a third-party, who have decided that Desktop Icons are unnecessary, and so delete all entries in my Desktop folder whenever XP is initiated. What I would like to do is to have my desktop show shortcut icons. I have no problem in devising a method to copy all...

I have a Visio diagram where the Page Tabs are not showing, (all pages are foreground pages). As an act of desperation, I installed "Sandrila Visio Super Utilities", and the page tabs appeared instantly. I would rather not have to pay to see the page tabs, so does anyone know; a). Why the page...

I have inherited a VB6 App. that calls a DLL using loads of different Entry Points. Most of the Entry Points work fine. However, when calling the DLL using an entry point that doesn't work, I get "Run Time Error '453'; Can't find DLL Entry Point EnableManualWrapup in antapi2" I have found...

The pointer in Word 2003 is fine when in the area already entered, however, when it is moved to an area outside the "already entered" area, it changes shape, to include miniature lines of text, that change in position relative to the "bar" pointer. I assume this is "Insertion Point Behavior"...

How can I find an explanation for the parameters used when calling WSOCK32 ? For example, the following is a snippet from some code I have been asked to maintain. Does anyone know what it means ?? Public Declare Function connect Lib "wsock32.dll" (ByVal s As Long, addr As sockaddr, ByVal...

I have the following Oracle Stored Procedure; Create or Replace Procedure CHECK_ACCOUNT_NO (SortCode In Char, Account_Check In Char, Check_Ind Out Number) As Begin . (Code which sets Check_Ind to 0 or 1) ; End; I...

Just out of curiosity - does Access have the equivalent of Oracle and DB2 system tables, ("SYS1....." and "SYSIBM....", respectively) ?

I have a column, (say Mixed_Value), in a table, defined as CHAR(17). It is populated from a dataset defined, (in COBOL), as follows; 03 Group-a. 05 Alpha-Value pic x(13). 05 Num-value pic s9(8) comp. So, an ASCII / Hex "Dump" of Group-a looks like; EMPRCENTTERMX CDDDCCDEECDDE0000...

I have created a package using the Package and Deployment wizard. When I try to run the Setup.exe, I get the following message - "Could not open the file named ......\SETUP.LST". There is obviously some sort of "lock" on the file, (which definitely exists in the same folder as the Setup.exe)...

How do I create a DCLGENCOPY ?

I have a form that contains an MS Flexigrid. At design time, Visible is set to true. However, when the form is loaded, Visible is reset to False, (used Watch in Debug). Even when I put the following code into the Form Load code; "If Me.grdPayments.Visible = False Then...

As above, is there a method of finding out the NT userid while executing a VB6 App.?

I have inherited an application written in VB6 that uses ODBC to communicate with an Oracle database. In design mode, it works fine, but when I compile it, and try to execute the EXE version, when it connects to the database, it presents a typical ODBC logon screen, (database name / username /...