DSXchange

When using webservice stage to call a webservice we are getting invalid keystore error. The webservice is working fine when tested in soap UI. In the security tab of webservice stage we have defined appropriate user id and password and also provided exact certificate path which was given by admin. E...

@Ray-Thanks..But I am getting the error.Report is aborting.

Is there any way from XMeta we can find .or running command through Ds Admin client.
Once I am running this command getting only 2 entry.

SH -c "`cat /.dshome`/bin/list_readu | grep DS.ADMIN"


Can you suggest something here.

Hi All,

Any idea for the mentioned issue. Also is there any way by which we can find the All the user details with their roles.

I need to list all the user name ,roles,permission.

Or Have to do it manually through Web console.

Thanks in Advance

Hi All,
I need to retrieve the
" Fatal error messages from datastage job log for latest run " and store in the file.

If anyone has done it ,Please share . I am trying to use the
Dsjob -logsum command.

Thanks in Advance.

Hi Ray/chulette, Thanks for reply. @Ray-Yes want to revoke/delete the user and roles in daily basis if user doesn't leave the organization. Can you elaborate how to plan and proceed. I have limited knowledge in Admin Side. I always create users and map role through WebConsole. The same thing they wa...

Hi All, Need one help for the below logic. I am not getting clue. I am receiving 2 files from External System . File A,Flie B. File A-Contain the list of the user of information server. File B-get the list of entitlements (role )for the corresponding users. After applying the Roles to the user , I h...

Hi all, We need to create a event table which captures information of each event for each job which happens during running of job. The table(EVENT_LOG) will have below columns. 1)Event_code(text) 2)Event_type_txt(1) example:-Error,Warning, information 3)Event_message example :-message from code 4)Ob...

I am reading excel file through "Unstructured data" stage available in DS 9.1 but it reads data wrongly, instead of varchar it read it as exponent, even though I have defined all columns as VARCHAR in DataStage. (I have tried with char, nchar but result is same). Example : In excel I have ...

Hi Guys , I have found one more solution to this problem. Just wanted to share , may be it will help some of you. Read the EBCDIC file with following settings. In format tab set String==>Export EBCDIC as ASCII option and In general Character Set = EBCDIC and Byte order=Big endian , read the decimal ...

Why don't you read it as char and transform it later in transformer.

Hi Guys, I have found a solution to this problem, rather I would say workaround. I was not able to read these special character in EBCDIC format. So I have made mainframe to send me file in ASCII format . I did face problem while reading decimal fields of this ascii file but did some setting changes...

Arnd - Yes data is coming from DB2 database. And I see these characters over there when I query it. It is indeed surprising to see disability of datastage to read it properly because datastage is highly compatiable with DB2 as both are IBM products. I need to check with mainframe guy to see which va...

No its not..But my client is from northern europe.They have customers all over the world. Please suggest any solution if you have any ..It does not matter where the data is from..

Thanks for repling quickly.For standard LATIN-1 characters what should be the NLS mapping . Basically this data is from northern Europe.

The binary value of '@' which not getting read is "0110110 0110100 " . So how can this help? I can ready every data only problem with this kind of character using sequentail stage as source with below settings NLS MAP:ISO_8859-1:1987 Record Length=fixed Field Defaults Delimiter =None Type ...