DSXchange

Hi All,

Is it possible to create an App from the datastage code?

Regards,
Shilpa

Thank you Ray. The Enterprise search needs a Linux box and we are currently procuring one. Will have to try again once we have Enterprise search operational.
Marking this post as workaround for now.

Hi All, I have been trying to work on IGC 11.7. I have a windows installation. I was trying to open Governance Monitor. It opens up but shows 0 connections. No data to display in "My import areas". No data to display in "My connections". Error occurred in "Highest rated asse...

Thanks Chulett. It worked. Marking this as closed.

Hi, We have a situation. The source is a comma separated text file with data as below: Country,dDate,ENm US,2016-06-22,Smith UK,2015-03-03,John US,2016-15-10,Rose We are trying to read the data using a sequential file. Tried 2 approaches: Read everything as varchar and then used IsValidDate along wi...

I realised that the order was going wrong after the filter stage which actually filters the header/trailer. Hence, 1st CI and Filter stage were executed in Sequential order and the 2nd CI and the custom made stage were executed parallely using RR algoritm and the copy stage in between was run parall...

Thank you Mike for the solution. Executing the stages in sequential mode solved the issue.
But a question here on the "undo" of partitioning in the final stage. We dont have any "undo" collection method in the final sequential stage.

I am marking this post as resolved.

I tried 2 ways- 1st Column Import and Custom made operator as Round Robin and Filter, 2nd Colimn import and Copy stage as same. Another way was - 1st Column Import and Custom made operator as Round Robin , filter as hash and 2nd Custom Import and Copy as Same. Both of these are not yeilding the righ...

Hi, I have a datastage job which runs on a 3 node config and the flow of which is- Seq File -> Column Import -> Filter -> Column Import -> Copy -> Custom made operator. Column Import, Copy and Filter stage run in default parallel execution mode and Custom made operator runs in sequential mode. Could...

Yes ArndW. The BitExpand function is under /Function/Logical.

BTW the datastage version is 8.7

Hi All, This issue is resolved. I tried Seq(In.Column) and then used a bitexpand function. It worked. Just a brief: As I mentioned it was an ebcidic file, I was getting "?" for this column and then when I used a Seq function, it gave me the decimal representation of it which was 26 and aft...

Thanks ArndW for the reply. I am using datastage 8.7.

Hi, I have a situation wherein I am reading Ebcidic data from a CFF stage. 1 of the field is defined as FLAG (PIC(X1)) ie it is read as char(1). This field is being sent to a target sequential file and the data type of this field in the sequential file is "binary" which means the output is...

ya the problem is solved.

Yes in the command line I am able to get the result.