DSXchange

Please let me know how to save this information in text file

How to save this jobname, endtime..etc in file?

Hi All,

I am not able to export the datastage jobs with executable but not designs. When i am selecting this option from designer then export is disabled not allowing to export. Please let me know the issue and also let me know how to do from command line.

Thanks

Sorry, not multi instance job, RCP only. i have this issue in more than one table. but for example i told 1 table

Hi Chulett,

I am using multi instance job and schema files to process 100 tables data. is it possible to use these functions in multi instance job or in schema file? because each table having different set of columns.

Thanks

Hi, I am reading the data from Oracle database and creating file(same process for around 100 tables).these are 1 to 1 straight mappings,So i am using schema files. i have one table having 3 columns but last column datatype is Varchar2(4000). but when i am trying to write the records in files, record...

But we are not able to login web console. we don't have separate admin team also.

hi,

we are using different credentials for datastage and unix. we changed unix admin password, now not able to connect to datastage. do we need to change same in any datastage server file?

Thanks in advance

We have to send this data to downstream system.I think downstream can handle this data . the question from downstream system is why the file data not exactly same as database.
now it becomes like quality issue.


Thanks
Mallikharjuna Reddy

Thanks Chulett

Hi, We are using RCP and schema files in our etl jobs. I am extracting data from table and loading in file. I am facing 2 issues 1) space is prefixed for decimal values, when i tried to load in file. Ex: if value is 10.1 in source then " 10.1 in file, one space before value 10. 2) if source dat...

i have to execute the dsjob from script, i have created one value file name: test. but when i try to use the value file in execution command it is throwing error like "$PROJDEF" not found. but projdef is first parameter.
please let me know the execution command from unix

hi, i have to execute dsjob through script. i have created one parameter file for the same and trying to executing through below command. "ParamList"is the list of parameters ${DSHOME}/bin/dsjob -run -wait -warn 0 -jobstatus ${ParamList} $p_DWA_PROJECT_NAME ${JobName} job is executing but ...

hi,

I have created all the parameters in one script ex:param.sh, i want to use this parameter script in my main script, please let me know the execution command for executing dsjob with these parameter script

hi,

i am using RCP and schema files in my jobs . i am receiving date in iteger format like "20150322" but i want to change format 'mmddyyyy'. is it possible to change in schema files.

Thanks