DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 8 matches
Author Message
Workaround Reported
 Topic: Create HIGH HEX value
kmare

Replies: 9
Views: 271

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 08, 2018 7:06 am   Subject: Create HIGH HEX value
Hi ,

we agreed on populating default values Laughing Laughing
Thanks for your time .
Iwill close this marking as workaround.
Workaround Reported
 Topic: Create HIGH HEX value
kmare

Replies: 9
Views: 271

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 07, 2018 1:10 am   Subject: Create HIGH HEX value
Thanks Ray, It gave the same out put (HEX value =40) as earlier for eithy scenarios with and with out conversion like
stgvar- char(255)
col - Str(stgvar,30)

AND
output column- char(255).

...
Workaround Reported
 Topic: Create HIGH HEX value
kmare

Replies: 9
Views: 271

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 06, 2018 6:48 am   Subject: Create HIGH HEX value
Hi Franklin,
Thanks for your reply.
You are correct as we do this transformation in ASCII set up and write to EBCIDIC file using CFF stage and not sure how datastage would understand our generated ...
Workaround Reported
 Topic: Create HIGH HEX value
kmare

Replies: 9
Views: 271

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 06, 2018 5:10 am   Subject: Create HIGH HEX value
Hi Franklin,
Thanks for your inputs .
I tried as you suggested but its not working as expected.
1)stagevariable:- Space(30) or ' ' -(tried with both)
2) Convert(' ','xFF',StageVar_1).
And ...
Workaround Reported
 Topic: Create HIGH HEX value
kmare

Replies: 9
Views: 271

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Aug 03, 2018 3:20 am   Subject: Create HIGH HEX value
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Dear Gurus,
I have a requirement to create a trailer record of length 30 with HIGH hex value (FF) in ebcidic format,fixed width so that mainframes can invoke it ,able to create one "FF" using Conver ...
 Topic: Way to generate automated Excel templates?
kmare

Replies: 8
Views: 2772

PostForum: General   Posted: Fri Apr 01, 2016 8:25 pm   Subject: Way to generate automated Excel templates?
Thanks craig / qt_ky ,

I am not familiar with HTML language and in this HTML approach can we merge 5 different layouts ?..

I am exploring this , once my data is ready in a tab , need to move ano ...
 Topic: Way to generate automated Excel templates?
kmare

Replies: 8
Views: 2772

PostForum: General   Posted: Thu Mar 31, 2016 11:22 pm   Subject: Way to generate automated Excel templates?
Thanks craig & mamu kim .

@ Mamu Kim , Could you please explain this in little more details ?..

build table tag. Then row tag. Field tag.

Field value. Close field tag. Close row tag.
...
 Topic: Way to generate automated Excel templates?
kmare

Replies: 8
Views: 2772

PostForum: General   Posted: Thu Mar 31, 2016 3:07 am   Subject: Way to generate automated Excel templates?
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Champs ,

Team is generating an excel report with the batch cycle run details manually which takes 30-45 mins every day and I am in a process to automate that report.

Except cosmetic changes (h ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours