DSXchange

Hi, I need to convert the Julian Date to date of format 'YYYYMMDD'. I read in the forum that the DateFromJulianDay should work and give the date in format 'YYYY-MM-DD'. My input date is 2008354 (CCYYDDD) so this should be 2008-12-19. I used DateFromJulianDay(StringToDecimal(Trim(INP_2.DATEP))) but g...

Thanks Ray,

That was the poroblem .. after installing NLS things are working fine..

thanks

Hi, We have migrated DS to a new server. I have exported the whole project and imported the same in the new server. When I run the job from the director it gives me following error... Parameter not resolvable: DSProjectMapName Parameterization error: Parameterization failed. I could not find much ab...

Maximum number of PROCESSES allowed per user

Check the maxuproc id on unix with the help fo the command lsattr -EHl sys0 | grep maxuproc This gives the maximum processes allowed and check the number of processes running for your DataStage job. if it exceeds the maxuproc id then one usually gets the fork() failed error. Try to kill some of the ...

>##E TOIX 000138 17:59:20(001) <Sequential_File_0> At least one filename or data source must be set in APT_FileImportOperator before use.
from this error what i gather is that you should atleast provide part of the file name
example : C:\folder\partfile*.txt

Hi, Thanks a lot Ernie.. that would be really helpful. I will surely try the server job. In the meanwhile i would like to ask sumthing else too. My sample XML file is as follows: <?xml version="1.0" standalone="yes"?> <sdnList xmlns:xsi="http://www.w3.org/2001/XMLSchema-inst...

Thanks V for the help 1)In "Validation Settings" tab ' log reject errors' are checked 2) we tried all possible combinations of Fatal Error Warning setting , not working. We have a defined a reject link from the XML Input Stage , no supposed rejects are captured here. 3) we did go through t...

Hi, Yes I tried xsi:schemaLocation="Yourschema.xsd" in the namespace declaration. Still the validation is not happening. Could you plz tell me when Validate schema is checked; what kind of validations are performed? For e.g. if a new tag is added in the input XML file, which is not present...

sorry about the previous post

'' We had a similar kind of problem , but our join keys were Char8 and Varchar8 . THe result as has already been mentioned is weird. "

We had a similar kind of problem , but our join keys were Char(8) and Varchar(8) . THe result as has laready been mentioned is weird.
So we made both the join keys data type same and have followed the same principle in every job that has a JOIN Stage , to keep join keys data type same ( even lenght)

I have an XML input file to be parsed into a flat file/DBMS. I need to validate the input XML file against a XSD schema file. XML Input Stage Details --------------- Include namespace declarations - Checked Validate Schema - Strict Namespace declaration: xmlns:soapenc="http://schemas.xmlsoap.or...

I have an XML input file to be parsed into a flat file/DBMS. I need to validate the input XML file against a XSD schema file. XML Input Stage Details --------------- Include namespace declarations - Checked Validate Schema - Strict Namespace declaration: xmlns:soapenc="http://schemas.xmlsoap.or...

We once got a fork failed error , similar to what you have mentioned. The problem was that the MAXUPROC id had reached its limit. The system engineers had to reset this value in unix box and restart it.

try specifying 'Field Delimiter' = end instead of 'Record Delimiter'=end