DSXchange

hi,
iam trying to query universe through datastage administrator. i have given command LIST.DICT DS_JOBOBJECTS.The error which iam getting is syntax error:un expected sentence without filename. plz help me.

cheers;
abhi

hi Ray,
Thanks for helping me to find a soultion, iam going for command line approach which iam running from dsxengine.As u said that the first step is to create a datadictionary and afer that use commands, how to create a data dictionary.

cheers;

hi,
can u please list the command line utility which helps in doing this.
can u plz expain the utility used.i have stuck up with this problem for a while.

cheers;
abhi

Hi, how do you create data dictionary in universe.when i run the command list.dict ds_jobobjects from voc, it comes up with a error that unexpected error without filename. when i went to find information on universe, it says that one should create a datadictionary, only after creating the datadictio...

Hi, since odbc drivers are not feasible to connect to universe, we are using command line interfaces to connect to universe.what we are doing is retrieving data from universe, use command like retrieve ,is there any command line utility to get information abt stages, like which is the source or sour...

hi, we are using command line interface which runs from dsengine.we are communicating universe repository by commandline interfaces.i want to know abt universe, as i read the file i came to know that all the tables are referred as objects in universe, and is in ds_jobobjects. i want to know the comm...

Thanks Ray for your help-you never kept our issues unresolved.

Its 1400 post now- and we know you would have many more

:D

..........Sorry I mean 14000........and its still going!!!

Hi Avishek Though I did not understand your req. this might be helpful ,When you want to process all the files which has a particular pattern why don't you use Folder stage. Thanks My doesn't know what is the file name. So I cannot use this parameter. What I know is the file pattern.. Like Unix use...

Use the job parameters and set their values in before job as suggested by Ray and you will have value from database. I think I am not able to explain my requirements: In a Unix directory I have a file. My job knows the direcoty path at run time and also knows the first part of the file name. I want...

I forgot to add the main requirement: Actually I do not want to hard code the file name in the Sequential stage.. I know the pattern <Some ID field>_<FileType>_<TimeStamp> for examle 1121_UCSINV_10192006082945.. at the time of running the job we can hard code the first two values. I need to run the ...

Hi I need to get the file name from a Database table(DB2). The table has a job name and file name cross reference.Then pass the file name as a job parameter to the sequential file which processes it. I would like to have a before job shell which gets the file name and passes it to the job parameter....

ravindrag wrote:i have a column xxxx it is of format yyyy/mm/dd DATE datatype(8) i have to see whether it is a valid format or not and if it is valid i have to load to target TIMESTAMP(30)? how can i see if it is valid or not

Search the forum...there are a lot of post on this subject.

The license validation has been problematic since way back. Each version works a little bit different. One version of 7.5 counts every client as a license seat in use, so if I start 10 Designers, I've used up a 10 seat license. If 10 folks startup a Director each, then there's no seats left for Des...

License connections are driven off the MAC and IP address, if you can figure out a way to spoof those then I think you can get around the security. Otherwise, welcome to IBM pricing schemes. I have heard something like that where only a single client logs to the datastage server and then you connec...

We have both Datastage server license for 5 user and 4 CPU...now we need to increase the user limit.. Now the vendor is asking almost equal amount of money which we used to buy the whole new software...it is really stupid.. Does it really cost that much to add users? Again if we create a generic log...