DSXchange

Thanks Eric But DataStage should process strings as characters and not bytes, right? If we set up the NLS at UTF-16 and if there are characters that occupy more than 2 bytes, will DataStage parse a string as characters or as bytes? Also does this mean the NLS setting of UTF-8 is not set correctly? W...

Hello, We are processing non-english character fields (European) through DataStage 8.0 by setting both DB and DS in UTF-8 format. The data is finally getting loaded into SAP. One open challenge we have here is when applying some transformation to fields having non-English characters. There is a sour...

Thanks Ernie

We are using the 8.1, we need to implement the solution in parallel job. Please suggest.

Hi All, We got a requirement to generate an XML file like given below. <?xml version="1.0" encoding="UTF-8" ?> - <SERVICE_USER_ALERTS xmlns="http://www.cardinalhealth.com/master/SERVICE_USER_ALERTS" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:sch...

Team,
I need to do MFT routing using UNIX. Could you please help me by providing appropriate command for routing. Also I heared that there will be option to execute post run script. Please provide the syntax to do this operation.


Thanks in advance.

Hi, Please look at this below unix command " if [[ (28800<=72000) ]];then echo "Source File Is Not Available " | mail -s "Hourly load job seq_Hourly_SPD_PYXIS_ADM:" xxx@yyy.com -r dsadmd@yyy.com; fi;" this command executing fine in unix environment , but when i tried to...

Version: 8.1 I did not understand the question on user registry. How can I find out this out? Are you referring to linking user ids through windows active directory or through Linux OS? Can you please elaborate? This is to find out if there is any way we can customize(add/delete) the existing privil...

With transformer i have to create three output links to make one record into three records , generally i have to create max of 54 records for each input records so i hope its not a good method to use trasformer

it's an type of access. Datastage user will not allowed to edit the job in designer.

How to restrict the read-only user to edit/manipulate Datastage administrator variable in production, even though access grant has read-only, they able to edit the variable. Please suggest.
Regards,
Jay

Thanks Eric. I'll explore more on converting ISX to XML if the uncompressed XML format from the tool is similar to the one we get when we do an export. But If I have to run dscmdexport.exe, I need DS client installed on a system. Is there a way a user who is not having a DS client installed be able ...

We are using DS 8.0. Need quick help to confirm if we can export DataStage jobs from server side in XML format. As far as I know, istools utility can be used to export jobs from server side but the format is ISX and not XML. One of our requirement is to export jobs in bulk in XML format and parse th...

Thanks for the confirmation Robert. This really helps.

Hi, Can anyone confirm if there is a separate ruleset for country 'India' as part of IBM Information Server suite 8.5 or 8.7? We could find some documentation on rule sets for indian addresses based on area which includes zip code, country, state & district. Is the Indian Address Rule set availa...