DSXchange

Hi, I have written a very simple routine as below. PDate = Trim(Arg1) IDate = Iconv(PDate,"D") Ans = Oconv (IDate, "D") Following are some test results Case 1 Input : 09-09-29 Output: 09 SEP 2029 Case 2 Input : 09-09-30 Output: 09 SEP 1929 Can you let me know how does the Century...

Pls note the following for JobMonAPP (Job Monitor): 1) JobMonAPP runs on the ports listed in the following file: /ascential/apt/QX/etc/jobmon_ports 2) JobMonAPP can be started/stopped using the following command: /ascential/apt/QX/java/jobmoninit Usage: ./jobmoninit [ start | stop ] [APT_ORCHHOME VA...

If you are sure about you Config file then

Check ur /tmp

bdf /tmp

If it is 100% then the error is because of that

Often when u get DS errors abruptly do give a check at /tmp....
that the trouble maker

Tx
Latesh

Hi, Would just like to share some features related to the kind of work you are doing... You can use the PweXport.exe utility provided by DS present at (<Client CD>\Utilities\Supported\PWEMDExp) This helps one to export Prism Table Definitions to the DataStage repository One can use the CFF plugin st...

Hi, I wanted to know how do we use Vector Columns. Following is my code structure 1. Input: Sequential File (Col0,Col1,Col2) 2. Make Vector: converting the 3 columns into one 3. Output: DataSet (Col) Now the output data set has the schema as below record ( Col[3]: string[max=10000]; ) Wanted to know...

Hi
Based on my experience with installation of DS 6 on HP UX 11i
Check the following

dsadm user does not have full permission to the installables directory and all the files underneath it.

Tx
Latesh

Thanks Teej, I also had a case opened with Support, not much help though. I did then implement my problem using a BuildOP.. Really enjoyed making one, My First One.... Adding the sample code for others reference. It reads 2 files 1. Containing my input file records having the GMT Timestamp 2. A File...

Hi , I was exploring the Transformer functions and this did work to an extent TimestampFromSecondsSince(3600, "2003-12-04 23:55:00") Gives the output as 2003-12-05 00:55:00 However this lead me to another error; I tried to add a stage variable of timestamp data type as second parameter; wh...

Hi, I need to add an hour to the value stored in a column of data type TimeStamp. Could not find any direct function to do that , Could ne one guide me as to how to write such a code in datastage and use that in a transformer derivation eg If the input file record contains 2003-12-04 23:55:00 then i...

Hi Not sure of any direct method, however try exploring the options in the DS Director..Job..CleanUp Resource; Select the Show all process radio button; then for each process in the upper pane, you will get a list of processes in the lower pane. Info like Jobnames, windows machine names is also disp...

I had got a similar error, and reason could be
1. MedClearODBC does not exists in the .odbc.ini file
pls check the name, case...

Latesh