DSXchange

HI Welcome to Dsxchange...! We can find the files which are older then certain period of time by using the following command. 1) find . -mtime -n -print 2) find . -ctime -n -print # c indicates the creation time. where n represent number of days old. but it give you all the files which have been mod...

HI

Yes we can get the job level parameter information from the unix environtment. The command to be used is

dsjob -lparam <project name > <job name>


for further help do go though the server.pdf document under the heading
Command Line Interface near about 700 page....

Please confirm if you are migrating the jobs or the data from one server to the other. If you are migrating the data then we can use a simple command to tar and then... scp to migrate the data form one server to the other. If you are migrating the Data Stage jobs then Yes, version control can be use...

Hi, You can get the detail of the no of Jobs in a particular project by using the following command line interface. dsjob -lprojects you will get all the project that are attached to a server dsjob -ljobs <project name> will give you all the job in the project. for further information on the same go...

Not very sure of about the FTP, but if i have understood your requirement right then, you can use a SCP command. What does SCP do? SCP - secure copy.... It transmit the file from one server to the other in a most secure form(internally it uses some algorithm to encrypt the file and send it to the de...

-report is as good as the jobinfo but gives much more details then the jobinfo. It has got three return values as jobinfo 1 - finished OK 2 - finished with Warnings 3- Aborted. 99- Job not running. I understand if the stats of 1-3 indicates that the job is in executable form, that implies that it is...

I agree with Dsguru2B, I must be something with memory. Do check the amount of free space available for processing(running the JOb).

Thanks for the responses. -Jobinfo will give the jobinfo. But my requirement is that from the unix console is there any means by which i can know if the job(present state of the jobs) is in compiled state or not. JobInfo will help me partially. If the job is compiled and run then definetly it helps ...

Available options with the dsjob command are Valid primary command options are: -run -stop -lprojects -ljobs -linvocations -lstages -llinks -projectinfo -jobinfo -stageinfo -linkinfo -lparams -paraminfo -log -logsum -logdetail -lognewest -report -jobid -import So there isn't any option specified for...

I came across phantom error when the job was aboring with divide by zero error.... not sure about the job commit.

The only criteria should be the availability of the CPU and Memory. As along as the CPU and Memory are available we can submit as many jobs as possible.

To know that we have certain tools which should help you to know the CPU and Memory available on your server.

HI, How do we know that a dsjob is in compile state or uncompiled state? I know the following methods, please let me know if you have any other. 1) From the director we see the status of the job compiled or not. The reason why need this is that when we are moving the code from one system to the othe...

ISNULL is a function, which returns TRUE or FALSE
1- True
0-False

Regards,

If your aim is to find the no of fields in a record then we can use.....

awk -F'\t' 'END {print NF}' testfile


Not sure about the DCOUNT()

Regards,

As kumar said there should be any problem as such.

If the input data file are also moved from windows to linux then, be aware that the new like character will be replaced by some special character. Make sure to delete the special symbols before further processing.