Hi Guys,
I need to send a flat file to a mainframe system that has a field in the following format:
Filler PICX(3) value=binary zero
Can someone tell me how can I send a binary zero in to this flat file from my SSIS package?
How to send a binary zero to mainframe system?
-
- Posts: 278
- Joined: Thu May 15, 2008 9:45 pm
- Skillset: MVS
MQ
ISPF - Referer: sister site
Re: How to send a binary zero to mainframe system?
Are you expecting ASCII to EBCDIC conversion on the character fields so FTP as BINARY is not an option?
Regards,
Bill Dennis
Disclaimer: My comments on this forum are my own and do not represent the opinions or suggestions of any other person or business entity.
Bill Dennis
Disclaimer: My comments on this forum are my own and do not represent the opinions or suggestions of any other person or business entity.
- dick scherrer
- Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
Re: How to send a binary zero to mainframe system?
Hello and welcome to the forum,
If the only binary number you need to work with is x'000000' you don't need to worry about translation - x'00' is the same in ascii and ebcdic.
What does the sql code in the ssis package look like?
If the only binary number you need to work with is x'000000' you don't need to worry about translation - x'00' is the same in ascii and ebcdic.
What does the sql code in the ssis package look like?
Hope this helps,
d.sch.
d.sch.
-
- Similar Topics
- Replies
- Views
- Last post
-
- 6
- 2120
-
by sergeyken
View the latest post
Sun Oct 22, 2023 6:58 am
-
- 7
- 1985
-
by sergeyken
View the latest post
Wed Dec 23, 2020 6:39 pm
-
- 2
- 1542
-
by sergeyken
View the latest post
Sun Jan 26, 2025 3:07 am
-
-
Librarian - how to send a listing of members to a dataset
by MLK2348 » Tue Feb 27, 2024 8:21 pm » in All Other Tools - 4
- 3268
-
by enrico-sorichetti
View the latest post
Thu Feb 29, 2024 7:16 pm
-
-
-
Easy way to send PDS of source code to another user via inte
by mamustoe » Wed May 18, 2022 4:34 pm » in JCL - 4
- 1817
-
by willy jensen
View the latest post
Wed May 18, 2022 10:42 pm
-