| Author |
Message |
Topic: FTP from mainframe to Unix/Windows - Special character |
sub
Replies: 5
Views: 5472
|
Forum: Utilities Posted: Tue Jan 23, 2018 5:39 pm Subject: FTP from mainframe to Unix/Windows - Special character |
We are using the editor
https://winscp.net/eng/docs/ui_editor |
Topic: FTP from mainframe to Unix/Windows - Special character |
sub
Replies: 5
Views: 5472
|
Forum: Utilities Posted: Mon Jan 22, 2018 10:32 am Subject: FTP from mainframe to Unix/Windows - Special character |
| Kolusu, Thank you for the suggestion. The issue is resolved when I try to transfer from mainframe to windows. However the issue still exists when I try this command to transfer from mainframe to Unix. ... |
Topic: FTP from mainframe to Unix/Windows - Special character |
sub
Replies: 5
Views: 5472
|
Forum: Utilities Posted: Fri Jan 19, 2018 7:30 pm Subject: FTP from mainframe to Unix/Windows - Special character |
| I am using FTP command to transfer file from mainframe to Unix. The file has a text field. The special characters "[" and "]" in the text field are getting converted into some garb ... |
Topic: Cache of a sequence object |
sub
Replies: 4
Views: 5665
|
Forum: Database Posted: Fri Jan 13, 2012 10:52 am Subject: Cache of a sequence object |
The table is a master table where no one has access to delete rows. There is no delete sql in any of the programs for this table.
This is a production system which is very stable. No system failure ... |
Topic: Cache of a sequence object |
sub
Replies: 4
Views: 5665
|
Forum: Database Posted: Thu Jan 12, 2012 4:36 pm Subject: Cache of a sequence object |
The problem I have is the sequence numbers are getting lost because of the cache 20 in the sequence object.
I have a sequence object defined with cache 20. Only 1 job (1 batch program) uses this se ... |
Topic: Create report using SAS |
sub
Replies: 9
Views: 7467
|
Forum: Application Programming Posted: Thu Jun 09, 2011 8:23 pm Subject: Create report using SAS |
| Thanks Chandra. It works for me now. |
Topic: Create report using SAS |
sub
Replies: 9
Views: 7467
|
Forum: Application Programming Posted: Wed Jun 08, 2011 7:51 pm Subject: Create report using SAS |
Hi,
Can someone please help me with a solution for creating a report from the below input file using SAS. My input file looks like this
STATE: New YORK
CITY : BUFFALO
DATE : 2011- ... |
Topic: Extract values from delimited file |
sub
Replies: 3
Views: 3862
|
Forum: Utilities Posted: Tue Jul 13, 2010 10:22 am Subject: Extract values from delimited file |
Kolusu,
Thanks, the solution you had mentioned worked. I was trying to expand this solution to convert more than 200 fields from a variable length file to a fixed length file. But learnt that ther ... |
Topic: Extract values from delimited file |
sub
Replies: 3
Views: 3862
|
Forum: Utilities Posted: Thu Jul 08, 2010 3:19 pm Subject: Extract values from delimited file |
Hi,
I have a pipe delimited file with 10 fields in a variable file. When a field doesn't have any value, there is nothing populated.
For eg, the input file will look like this
ABC|sds|3432|||4| ... |
Topic: Create multiple records |
sub
Replies: 2
Views: 2148
|
Forum: Utilities Posted: Tue Jun 29, 2010 2:50 pm Subject: Create multiple records |
| Thanks Kolusu. The results were as expected. |
Topic: Create multiple records |
sub
Replies: 2
Views: 2148
|
Forum: Utilities Posted: Tue Jun 29, 2010 1:23 pm Subject: Create multiple records |
I have a file which has the first 8 bytes as the customer id.
12CD1234
23CD3433
I am trying to create a output file that will create
12CD1234 AACD1234
12CD1234 ABCD1234
12CD1234 ACCD1234
... ... |
Topic: sort sum - expand output length |
sub
Replies: 1
Views: 2631
|
Forum: Utilities Posted: Fri Mar 05, 2010 1:24 pm Subject: sort sum - expand output length |
Hi,
I have a input file which has 2 fields. The layout is
01 INPUT-REC
05 CUST-NO PIC X(9)
05 CUST-DESC PIC X(30)
05 CUST-QTY PIC S9(10)V999 COMP-3
The input file has ma ... |
Topic: Extract last record only |
sub
Replies: 2
Views: 2354
|
Forum: Utilities Posted: Fri Dec 11, 2009 1:11 pm Subject: Extract last record only |
| Thanks Frank. It works for me. |
Topic: Extract last record only |
sub
Replies: 2
Views: 2354
|
Forum: Utilities Posted: Fri Dec 11, 2009 12:41 pm Subject: Extract last record only |
Hi,
I want to extract the first record and last record into a output dataset from a VBS input file. I can use STOPAFT=1 for extracting the first record. But I am not sure how to extract the last r ... |
Topic: Single quotes in Sort |
sub
Replies: 1
Views: 7287
|
Forum: Utilities Posted: Tue Dec 08, 2009 9:59 pm Subject: Single quotes in Sort |
Hi,
I am reading a file and writing the first 10 bytes of the input file into the output file. Also when I write the output file i need to include a single quotes (') before and after the value.
... |
| |