1. I've recently started using the program, and have read through the tutorital which was included. But I want to learn more about the syntax of the datastage "scrip-language".
Anyone know good books, cbt or other usefull information on how to get to know the program better?
2. Is there any way to make variables, use wildcards and other programming techniques, or setting the rules to a script language?
The reason why im asking, is that the rules doesnt seem to scale well?
I had a series of potential values i needed to convert, and i had to make this huges sentence:
Code: Select all
IF(ecc~v Attr ecc~RoleType Type:.:ElemDecl head~SenderRole Comp:.:InXML = "DKK", "A08", IF( ecc~v Attr ecc~RoleType Type:.:ElemDecl head~SenderRole Comp:.:InXML = "DDQ", "A12", IF(ecc~v Attr ecc~RoleType Type:.:ElemDecl head~SenderRole Comp:.:InXML = "DDX", "A05", IF(ecc~v Attr ecc~RoleType Type:.:ElemDecl head~SenderRole Comp:.:InXML = "DEA", "A09", IF(ecc~v Attr ecc~RoleType Type:.:ElemDecl head~SenderRole Comp:.:InXML = "EZ", "A04", IF(ecc~v Attr ecc~RoleType Type:.:ElemDecl head~SenderRole Comp:.:InXML = "GD", "A21", IF(ecc~v Attr ecc~RoleType Type:.:ElemDecl head~SenderRole Comp:.:InXML = "MDR", "A25", IF(ecc~v Attr ecc~RoleType Type:.:ElemDecl head~SenderRole Comp:.:InXML = "UD", "A13", ecc~v Attr ecc~RoleType Type:.:ElemDecl head~SenderRole Comp:.:InXML))))))))