Recent content by dja1

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