 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 9 matches |
| Author | Message |
|---|---|
 Topic: SDSF : COMMAND NOT AUTHORIZED |
|
| sam01 Replies: 1 Views: 3549 |
 Forum: Job Control Language(JCL) Posted: Thu Mar 14, 2019 9:04 am Subject: SDSF : COMMAND NOT AUTHORIZED |
| Hello,
i have the authorization to do this commande in JES2 : /D SMS but by bath, i have this message : COMMAND NOT AUTHORIZED And only by batch This is my batch : ... |
|
| Topic: Maximum size for a DSNTYPE LARGE DATASET |
|
| sam01 Replies: 1 Views: 4016 |
Forum: Data Management Posted: Fri Feb 01, 2019 3:38 am Subject: Maximum size for a DSNTYPE LARGE DATASET |
| Hello, i'am trying to allocation a Huge dataset wich size more than one To.
I wonder if there a maximum size for a dataset. I knwow the limit of a DSNTYPE LARGE Dataset in one volume : https:/ ... |
|
| Topic: SQL and STRIP command |
|
| sam01 Replies: 6 Views: 5127 |
Forum: Database Posted: Wed Jan 23, 2019 3:29 am Subject: SQL and STRIP command |
Thank's Kolusu, it works!  |
|
| Topic: SQL and STRIP command |
|
| sam01 Replies: 6 Views: 5127 |
Forum: Database Posted: Tue Jan 22, 2019 3:32 am Subject: SQL and STRIP command |
| Hello Kolusu, don't worry about the content of the dataset. I have changed it on purpose.
The quierie is good. Here is the syspunch : LOAD DATA LOG NO INDDN SYSREC00 INTO TABLE ... |
|
| Topic: SQL and STRIP command |
|
| sam01 Replies: 6 Views: 5127 |
Forum: Database Posted: Mon Jan 21, 2019 8:03 am Subject: SQL and STRIP command |
| Hello, no my dataset is in FB Format.
But i realised the strip command is unnusefull beucause when i remove it, the result dataset is the same !!! SELECT CHAINE!!';'!!DATEXE!!';' !!HEUREXE! ... |
|
| Topic: SQL and STRIP command |
|
| sam01 Replies: 6 Views: 5127 |
Forum: Database Posted: Mon Jan 21, 2019 3:16 am Subject: SQL and STRIP command |
| Hello,
i use this SQL quierie : SELECT STRIP(CHAINE)!!';'!!STRIP(DATEXE)!!';' !!STRIP(HEUREXE)!!';'!!STRIP(DATESAV)!!';' !!STRIP(HEURSAV) ... |
|
| Topic: Getting columnn name by using DSNTIAUL PARM(SQL) |
|
| sam01 Replies: 6 Views: 5022 |
Forum: Database Posted: Mon Jan 21, 2019 2:39 am Subject: Getting columnn name by using DSNTIAUL PARM(SQL) |
| Ok, i anderstood it's not possible. With DSNTEP2, the result is into the SYSPRINT and limited to 133 bytes records....
Thank's. |
|
| Topic: Getting columnn name by using DSNTIAUL PARM(SQL) |
|
| sam01 Replies: 6 Views: 5022 |
Forum: Database Posted: Sat Jan 19, 2019 11:09 am Subject: Getting columnn name by using DSNTIAUL PARM(SQL) |
| Hello,
i need both of them. The data and the column name. Is there an option with header or something like that to get the data and the column name with using ORDER BY ? Thnak's for your help |
|
| Topic: Getting columnn name by using DSNTIAUL PARM(SQL) |
|
| sam01 Replies: 6 Views: 5022 |
Forum: Database Posted: Fri Jan 18, 2019 11:04 am Subject: Getting columnn name by using DSNTIAUL PARM(SQL) |
| Hello, i would like to get the columns nalme with this :
SELECT STRIP(CHAINE)!!';'!!STRIP(DATEXE)!!';' !!STRIP(HEUREXE)!!';'!!STRIP(DATESAV)!!';' !!ST ... |
|
All times are GMT - 5 Hours |