Search results for query: *

Thank you both very much for replies, I really appreciate your help.

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...

Yes, it is. The question is how to get the parameters from an input dataset "into" the subquery. For example, if the dataset contains three records; London Paris Berlin How would I code a query that "looked" like Select * From City_Table where City In ('London', 'Paris', 'Berlin'); In...

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 ?

Thanks to everyone for taking the time to reply. I have plumped for Glenn's solution, as this seems the closest to my requirements. Thanks again David

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...

Hypetia Thanks very much - spot on. As a matter of interest, I found that if you run this code when Desktop Icons are visible - it switches them off ! Thanks again

Thank you for your responses, so far. However, I did ask "Does anyone know how to show the icons on the desktop using VB6 ?" - would it be possible to restrict any replies to actually answering the question ?

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...

Hypetia Thanks very - most impressive !!

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...

Blue Horizon Thanks very much - most impressive

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"...

V Thanks very much - extremely informative article - thanks again

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...