DSXchange

Run the OS level command using DSExecute() in a routine. Reference that routine inside the transformer. I have tried a similar approach like calling the command in command stage and then the COMMANT.OUTPUT value of command stage is fed to transformer directly. It is throwing an error of Command not...

Hello All, Can you please tell me, whether there is any inbuilt function or routine in DS to find the end-of-file . Currently I am not able to find an economical way. I am using ExecDOS before stage subroutine and calling a batch file that finds the EOF, also it is doing same in Command Stage, but t...

ray.wurlod wrote:DataStage does not recognize user DSNs. You must use a System DSN or a File DSN. ...

I tried System DSN and FileDSN as well, but its not simply appearing in the ODBC stage.

Hello All, I have to read the data from an excel file. Now for this I've created a user DSN with MS excel driver. I am using an ODBC stage for reading the excel. Now in this ODBC stage when I try to import the Metadata from an ODBC Table Definitions , it does'nt show me the DSN in the list. I am not...

kumar_s wrote:Make sure you are not using any relative paths. You can use return code to check the completion of the code so trigger the rest of sequence. ...

Using the sequence I was able to achieve this, but can't this be done in a single server job as my task is to do it in a single server job.

Does this XYZ folder actually get created by the batch? At compile time no checking is done for source and target file paths, so you won't see this error message then. Hello, Yes the folder is getting created. But what I think is may be the entire MAP is parsed before executing it completely. Hence...

Hello All, I am having a scenario where I've to achieve dyanamic file generation depending upon the data present in the files. Now that I've achieved using my target stage as folder stage, but the main condition is that there should be a folder XYZ created everytime this job is executed and the file...

We are getting a weird error while opening a job: - The error is Record J\126\V135S0P15 in file DS_JOBOBJECTS does not exist. When we click on OK button on this error message box, the job opens but all the links connecting the stages are gone but when we open any transformer then it shows all link d...

Hello Frnz, I have a Server job whose output is a sequential file Stage.Before these stage there is a Transformer stage and records passing the constraints enter this target sequential file.Now my requirement is that this file shud get created only when it has some data.Right now even if no records ...

So what i thought was that, if i can some how change the target file name which is given as a job parameter, at run time in a transformer then whenever the parameter is set the new file name will be there and hence a new target file will be generated. Just in case it was not clear in the previous p...

Hi Anupam Can You explain agai wt u r trying with varaibles V1,V2 Thanks Hi Arshad, What Anupam wants to say is as follows. StgOldKey = StgNewKey StgNewKey = Key StageVar2 = StageVar3 StageVar1 = concate all columns in this var. as col1:col2...and so on StageVar3 = if StgNewKey = StgOldKey Then Stg...

sb_akarmarkar wrote:Hi,


It is possible to divide file into multiple file with combination aggregator stage and folder stage....


Thanks,
Anupam

Can you please specify How??

Thanks & regards
Parag

Is my understanding of your requirement right? Source Flat File col_1 col_2 col_3 Material_Type_Code 1 A P Metal 2 B Q Cloth 3 C R Leather 4 D S Metal 5 E T Stone 6 F U Stone If you input file is something similar to above. How are your expecting your output apart from the Material_Type_Code going ...

Hello All, I am having a requirement where i am getting a source flat file, in which there is a column which specifies the Material Type code. Now i have to generate a new target file for each type of material type code. So what i thought was that, if i can some how change the target file name which...

Hello I am having a date in source data. Now i want to check that if the Source Date is less than 01-12-2006 then 1 month should be added in the source date else same source date should be populated. i.e source date = 12122005 Then if 12122005 < 01122006 then Ans = 12012006 Now using ICONV and OCONV...