DSXchange

[quote="ArndW"]To convert to "?" in a transform stage, use "CONVERT(CHAR(000),'?',In.StringColumn)" ...[/quote]

Thanks a lot ArndW.
That is working fine.

Hi, We are facing problem with ASCII Nulls in fixed-width sequential file. This fixed width sequential file is getting created in server job which has CHAR(20) column. In this column, sometimes data coming in is not exact 20. This file further used in parallel job where we are converting it into dat...

i AM NOT SURE IF YOU HAVE TRIED THIS

OPEN DS DIRECTOR> JOB> CLEAN UP RESOURCES

VIEW ALL > VIEW ALL> SERCH THAT JOBS PROCESSS AND SAY LOGOUT AND IN THE AME WAY KILL ALL PROCESSES FOR THAT JOB. AND THE JOB WILL B AVAILABLE
PLZZ LET ME KNOW IF MORE INFO IS REQUIRED.

THX

We are using our development id to run some scripts but for some file transfer we required to login with other user id. Currently we use su , but the issue we face is it asks for password. So, we are unable to perform this operation through script. Do you have any ideas/suggestions ?

Is there any way to switch the user login between the current session? We are using 'su' command but it is asking for the password.This we want to implement in script so there any way to pass password as an argument or any other command?Please help us.Thank you.

Hello All, My requirement is that all warnings related to the job should be written to the file in the unix.I used DS routine as follows $INCLUDE DSINCLUDE JOBCONTROL.H Job = JobName JobHandle = DSAttachJob(Job,DSJ.ERRWARN) StartTime = DSGetJobInfo (JobHandle, DSJ.JOBSTARTTIMESTAMP) EndTime = DSGetJ...

Hi, We are writing scripts for running DS parallel jobs.The job status option of dsjob we are fetching to get the status of the job execution.We are using -14 value of jobstatus to display that job is time out. After running the script the status returned by the dsjob command is aborted.But in actua...

Hi We are creating shell scripts for running our DS parallel job.For all scripts we are maintaining common parameter file for all job parameters and environment variables. In some of the jobs we used $APT_DUMP_SCORE environment variable. We used the hard coded value of the parameter in script as 'AP...