DSXchange

Hi , I have a requirement to keep a running counter in a seq. This counter is different from the counter available in the start and the end loop activity. This counter is incremented or decremented depending upon conditions checked in the seeq. I have tested with the User variable activity that we n...

Hi , I am getting this error while i used an start and end loop activity in a seq. Any clue on this . . . .welcome . The loop is perfectly closed . Compiling: Source = 'RT_BP9210/JOB.1484023322.DT.1457548960', Object = 'RT_BP9210.O/JOB.1484023322.DT.1457548960' **************************************...

Your shared library search list (LD_LIBRARY_PATH or similar) is inadequate. This is probably because the user invoking dsjob has not executed the dsenv script in the DataStage engine directory. ... Hi Ray I have run the Dsenv in the login that i executed the dsjob but its still throwing the same er...

Hi , could somebody give an idea of what this below error is and how to overcome the error. . . U are Welcome > This is what i am seeing in the telnet when i try to invoke a dsjob command line interface command. There are execution rights available for my user id but still its failing to show me at...

Yeah thats a good idea and a fine workaround.

Hi my requirement goes as follows 1) execute a job/seq in a execute command activity which will in turn invoke a thridparty scheduler from the unixbox. 2) Retrieve the job status of the job executed in the previous stage. 3) loop untill all the jobs/seq are executed which is kept in a list file I am...

Is it possible to deploy a hash file stage as in server

Hi ,
Are there any incomatiblity between the server and parallel engine that we should take care when we need to migrate from a server engine to a parallel engine.

Hi,
Can we use the hash file stage in Parallel engine . . . clarify please ?

Hi ,
Any idea of how to take the tables used in a job.

You can use fileset stage instead of sequential file stage . The fileset stage has the option of overcoming the file size limit.

Hi Could anybody show light on the importance of these stages other than the below said Dataset Fileset Sequential ====== ====== ========= Persistant storage Anything to say ? Anything to say ? Anything to say ? Carries formating info Anything to say ? Could the stage usage importance be highlighted...

If the decimal range is half the range of the float then there is a possiblity of wrap in the numbers to a negative value which would be passed as input to SQL querry.The ultimate result is that the point untill it doesnt wrap will pick records after that it will not pick records as it doesnt satisf...

I dont think so that fileset that you have created is the same as the one datastage creates for you . . . Manuall creating files is something different than you create a control file like fileset( ie fileset creation by datastage would have its own kind of information embedded in it ) Try using some...

Hi , Just check the partition type that you have chosen for the master link as DB2 and check whether the partition type for the reference link is entire or Auto ( By default reference stages would have a Entire partitioning). The dataset also stores the partition information .Hence while you write t...