DSXchange

Hi All, I have to send an XML file data into csv file.While doing this i am getting the following error.Can some one please help me how to solve this. [color=red]APT_CombinedOperatorController,0: Operator terminated abnormally: Terminating with exception:APT_BadAlloc: Heap allocation failed.[/color]...

In my scenario what i have to do is I have to capture the ds director log and i have to sent this log to the support personnel if the job got aborted. For example if i am extracting the data from a database(ex Oracle)in ds job we need to give schema name & username & password.If i gave wrong...

Hi, How to we compare the source column timeStamp with current timeStamp. For example i have the source column'ABC' which was updated in database 7:30PM.I am using this column as a target column,and i just want to compare this column time stamp in database with current datastage job time stamp wheth...

Hi,

Does anyone have idea how to append the current timestamp for a existing Target column in transformer stage.

Thanks in advance.

Thanks & Regards,
Vijay Katneni.

Hi All, Does any one have idea how to delete the file after the successful execution of job using the Dos command. For my jobs Datastage server and clien tolls are installed in windows.The job will pick the sequential file from a directory in windows. After picking the fail the job should run and th...

Hi All,


I am getting the following error while running the parallel job on my Personal Computer on windows environment.Can any one help me for resolving this problem.

Error [b][color=red]This jobtype is not currently runnable on this platform[/color][/b]



Many Thanks in Advance.[/b]

Hi,

Does any one has any idea how to install datastage 7.5 server in UBUNTU operating systme?

Hi,

i am getting the following error while trying to extract the data from oracle database.

Oracle_Enterprise_0: Access to sys.dba_extents is required but not available; please
see your database administrator for select privileges.

Can anyone help me what actions i need to be taken.

Hi, Can any one help me how to transfer the file from unix box to windows box through SFTP.Here the description, In my case datastage server is located in Unix,after finishing the job i have to store the file in Windows.This should be done by automatically,i.e. whenever the file comes into unix dire...

Yes,we can but the problem is the files has different metadata.


[quote="Minhajuddin"]You can use the funnel stage for this.[/quote]

is it possible to do within one job.



[quote="ray.wurlod"]Two jobs. One overwrites the file. The next appends to it.[/quote]

Hi,


Can any one help me how to concatenate the text files in datastage without using CAT command.

Hi,

Can anyone help how to aggregated the time in datastage,like in my input the time is 09:35:52.I want to rounded this time as 10:00:00.If it is 09:25:23 i need to be rounded as 09:00:00.

Thanks&Regards.

Hi,


Can anyone help me how to move a file from unix to windows through SFTP,what are the parameters we need.


Thanks&Regards,
Vijay Katneni.

Using Web Services[/b]

Hi All,

I need to send the records to another interface by using Web servces. Can any body sugeest what are the stages need to be used in sequence to do this functinolity?