DSXchange

Thanks ray.wurlod for your pointer to UniObject manual in IBM site. And i had a short glimpse on that. Here i like to share some more informations regarding . Please correct me if i am wrong. 1. OLE - O bject L inking and E mbedding 2. UniObjects - An interface to UniVerse and UniData databases from...

Thanks ray.wurlod, Can be elaborate your answer for these questions, 1. 1. How the whole Database management system(UniVerse/DataStage/UniData) can be picturized through its each element. Whether the definion of DataStage can be that it is Powerful tool written in UniVerse BASIC to perform all ETL o...

Thanks ray.wurlod, Can be elaborate your answer for these questions, 1. 1. How the whole Database management system(UniVerse/DataStage/UniData) can be picturized through its each element. Whether the definion of DataStage can be that it is Powerful tool written in UniVerse BASIC to perform all ETL o...

Thanks Kduke and ray.wurlod. Here I would like to have some clarifications over your answers as, 1. They are written in DataStage BASIC and are cataloged with "DSD_" prefixes Fortunately, I do not see any difference in the documentations of DataStage BASIC and UniVerse BASIC other than the...

All, I have a few questions on DataStage Server Architecture as given below. Before that i recommend you all to have a glimpse over this ray.wurlod's post on DataStage Architecture 1. What are DataStage Objects, UniObjects and ActiveX objects? And what is OLE Server(with expansion)? 2. What are help...

Thanks kduke, Though i try to list out all Job Parameters defined in a Job without adding any dictionary items in the DataStage table DS_JOBOBJECTS, adding dictionary items in DS_JOBOBJECTS seems to be easy task to do and makes sense for future use also. Here, I got the list of dictionary items whic...

Visit this page,

viewtopic.php?t=99047&highlight=ParamDefault

rhaddur, Job parameters defined in a Job are stored in the ROOT record of UniVerse table DS_JOBOBJECTS in version 7 and earlier versions as Kduke said. Here are position numbers(Field No) in DS_JOBOBJECTS file for each element in Job parameter properties. Parameter Name - 14 Prompt - 16 Type - 19 De...

Of course Ray, Deliberately I do not like to disturb(modify) the any DS Server Engine files(DS_JOBS,DS_JOBOBJECTS,...) unless our requirement urges to do so. Here I am just searching for an elagant way to content this requirement as without adding any entries in those files. Thanks Kim, I got the po...

All, Through my recent exploration in this site, I have got a clue to proceed further that KimD has created a DS Serverr Job(one of the creations in ETLStats) to fetch all Job parameters in a Job using UniVerse SQL statements without using keyword ASSOC.WITH. I was but unable to find the technical d...

Ray, I request you to expand your answers whererin you specified, Read your UniVerse/SQL help/manual for information about the ASSOC.WITH keyword. Here which manual do you point out, 1. UniVerse SQL User Guide 2. UniVerse SQL Reference OR Any others After looking at the usage of keyword in those doc...

Ray, I am able to see those specific columns(Association, Position, and Type columns supporting multivalued data - UniVerse, UniData, and Hashed File) in the Column grid. And as well, i set the values for those columns as, Columns support multi-valued fields: Association - JobParam(All) Position - 1...

Ray, I am not much aware of your statements here. So I have a few questions on your answer. please clarify, Have you defined the pertinent multi-valued columns to be multi-valued in your table definition? If you have, you should be able to use the "normalize on" check box in a UV or Hashed...

Hello everybody, I have been trying to list out Job parameters used in a Job, using UniVerse SQL statement in server Job, SELECT EVAL DS_JOBOBJECTS."@RECORD<14>" AS ParamName, EVAL DS_JOBOBJECTS."@RECORD<16>" AS Prompt, EVAL DS_JOBOBJECTS."@RECORD<19>" AS Type , EVAL DS...

Hello chucksmith, I have commented your previous version of your tool. When i posted a message at first (two months back), I did not come to know that your tools had been updated with some more functionalities. Really regretting about having been an ignorant of your tools updates. Absolutely nice to...