DSXchange

Thanks rajngt.

Is there a way to restrict users having DS Admin access as well? As these users can always go n unprotect the project.

Potentially only one user should have access to import jobs into this project.

Can I set admin rights at project Level?

Thanks

Hi All, have jumped from 7.5 to 8.1 Need help with restricting all but one users from importing jobs into the Production Environment/Project. Please suggest what all steps are required at Project level and/or User Access Level to make this happen. Is it possible to restrict job import access for use...

Thanks Ernie.

Issue was resolved by placing xsd locally. (Probably ds was not able to connect to online schema from unix box)

steps:
1) copy xsd to local machine (local to datastage)
2) modify path for xsd in xml files
3) import schema again from a file

Thank you.

Regards
Satish

Hi, Still in process of debugging above job. Could you please help me understand following error: extract_CMR..XML_HDR_Tran: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:NetAccessorException, Message:Could not ...

Was following this guide to read from xml file and write to a table. http://www.ibm.com/developerworks/data/library/techarticle/dm-0703xiong/ However, columns are not getting generated after mentioning the namespace declaration as: -------------------------------------------------------------- xmlns...

Thanks Ray.

Few relative links I found on DSX are:

viewtopic.php?t=126737&highlight=fmt

viewtopic.php?t=114616&highlight=

viewtopic.php?t=111302&highlight=

Cheers!!

Hi Ray, Length in source data is variable could be anywhere between Empty to 4000 chars; however, target can only store 132 chars max for that column. Could you please help me with a example of using either function, where I could still maintain following format. 'Key1<TAB>Note1' 'Key1<TAB>Note1' 'K...

Hi, Could anybody help me with Guides or tutorials for writing and using Datastage routines. Or could anybody suggest to do this without routines > source: oracle target: tab delimited sequential file requirement:I need to break a line into two rows if text in a row is more than 132 chars. col1: key...

Found the solution

"string1" : Char(9) : "string2"


Char(9) is a conversion function.

Cheers!!

Hi all,
could you please suggest how to add a Tab Space between two strings in transformer.

eg. A="ABC"
and B="XYZ"

I need output as "ABC <\t> XYZ"

Thanks in advance

Regards,
Satish

While my premium membership is still under review... Found this solution in unix: hexchar="FF" octchar=$(echo "ibase=16;obase=8;$hexchar"|bc) hexInChar=$(echo "\0$octchar") Could you please suggest how to embed this code in DS job. Via oracle char code could be found by...

given link says its Premium content

is there any work around?