DSXchange

As Mike noted, you don't need all that but rather simply switch from IsValidDate (which needs a date not a string) to IsValid with a parameter of "date" and the format string. ... Ok.. But does StringtoDate(TmpAcctOpDt,"%yyyy-%mm-%dd") function need the input date value in the y...

Thanks Craig and Mike.. But still not working... I reformated the input string from YYYYMMDD to YYYY-mm-dd in a stage variable and then used the isvaliddate function still not working .. and giving the same error below. APT_CombinedOperatorController,1: Data string '20000317' does not match format '...

Data string '20060517' does not match format '%yyyy-%mm-%dd': an integer was expected to match tag %dd.

Still getting this warning after using
below expression

If IsValidDate(DSLink2.ACCT_OPEN_DT) Then StringToDate(DSLink2.ACCT_OPEN_DT,"%yyyy%mm%dd") Else SetNull()

But that is how the data is and the code is and cannot understand/get the warning..

I am getting following warning.. Data string '20090102' does not match format '%yyyy-%mm-%dd': an integer was expected to match tag %dd I am getting input field as string as yyyymmdd .. trying to check if it is a valid date and converting to string to date.. If ((Trim(DSLink2.ACCT_OPEN_DT) = '') Or ...

Thank you Craig..please let me how to add one ..i am looking for it.

Hi All, Want to use reject link to CFF stage on source side or target side to know what records were unsuccessful in reading or writing. Not sure exactly where to set this option so we can collect rejected records . Tried in File options tab ,reject mode was set as "save" still not working...

Hi All, We are getting Cobol Input file with multiple record layout with different lengths and each record layout in it is a fixed format. There are 60types of records/record layouts in the input file and we are interested only in 10 of them. But we have seperate copybooks for each type of layout. T...

Thanks Pandeesh for your response.

Anyways to acheive this other than creating a custom PX routine for it?

Any inputs greatly appreciated..

Hi All,

Just want to encrypt only 2 fields (not the whole file) in a file and also should be able to decrypt those 2 fields in Datastage .

Any inputs , greatly appreciated.

Thanks in advance.

Thanks for your response Craig .. You mean to call System(99) function in a Routine activity stage right.? If so inorder to call System(99) function in a Routine activity stage I got to browse thru the repository path .. so for that I need the location of the function to use in Routine activity stag...

Thanks Ray for your Response.. But System(99) function , I am not able to find in the repository. When I am trying to use that function in UV stage .. it says Variable "System" not defined. Any inputs greatly appreciated. Could someone post Ray's message again , because I am not able to vi...

Hi Ray,

Could you please give the exact syntax from time conversion from seconds to datetimestamp format ?

Any inputs greatly appreciated.

Hi Ray ,
Thanks for your response..but I didn't find the System(99) function in the repository.. In which category of repository can we find this function ?
Any inputs greatly appreciated.

Thank you..

Hi Ray ,

Thanks for your response.. but I am not able to view your full content of the post , though I renewed my premium membership account .. so could, have informing the Dxchange support team , but not fixed so far.

could somebody post the message for me.

Thanks for your help.